IF formula with dates
Solved/Closed
CeskyWater
Posts
1
Registration date
Monday June 6, 2016
Status
Member
Last seen
June 6, 2016
-
Jun 6, 2016 at 11:40 AM
CeskyWater - Jun 8, 2016 at 11:22 AM
CeskyWater - Jun 8, 2016 at 11:22 AM
Related:
- IF formula with dates
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Jun 6, 2016 at 02:46 PM
Jun 6, 2016 at 02:46 PM
CeskyWater,
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.
=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.
Jun 8, 2016 at 11:22 AM