function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
teacup13teacup13 

Date Formula - Calculating earliest date

Hello-

 

Can someone pls help with building a formula for calculating the earliest of 2 dates?

 

It works like this:

  1. Field A: (8/30/09)
  2. 2 date fields but either one could be earlier than the other.
  • Field B: (8/31/09)
  • Field C: (9/2/09)

 

So i need to calculate the # of business days bt field A and field B (since it's the earlier date). However, either field B or C could change to be earlier than the other. I need to calculate the # of business days bt the earlest field.

 

Thank you!

TC13 

Steve :-/Steve :-/

So is your formula basically 

 

A  - (the earlier of B or C)?

 

or am I missing something?