IF formula with dates [Solved/Closed]

CeskyWater
Posts
1
Registration date
Monday June 6, 2016
Last seen
June 6, 2016
- Jun 6, 2016 at 11:40 AM - Latest reply:  CeskyWater
- Jun 8, 2016 at 11:22 AM
Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and end date, how do I set the range to obtain this information please?

Many thanks in advance
See more 

2 replies

RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
- Jun 6, 2016 at 02:46 PM
0
Thank you
CeskyWater,

=IF((B2-A2)/7>12,"Greater Than 12 Weeks","")


Where A2 is the Start Date and B2 is the End Date.

B2-A2 gives the number of calendar days difference then dividing by 7 gives the number of weeks.
Thank you Ryan, very helpful