You need to sign in to do that
Don't have an account?
teacup13
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:
- Field A: (8/30/09)
- 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
So is your formula basically
A - (the earlier of B or C)?
or am I missing something?