Report

IF formula with dates [Solved]

Ask a question CeskyWater 1Posts Monday June 6, 2016Registration date June 6, 2016 Last seen - Last answered on Jun 8, 2016 11:22AM
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 
Helpful
+0
moins plus
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.
CeskyWater- Jun 8, 2016 11:22AM
Thank you Ryan, very helpful
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!