IF Function Using a Date Range [Closed]

Report
Posts
1
Registration date
Thursday December 21, 2017
Status
Member
Last seen
December 21, 2017
-
 Blocked Profile -
I'm looking for a function that will assign a specific date or day of the month when another cell containing a date falls within a date range:

If C2(mm/dd/yyyy) is between the first and the 7th of the month, then the answer is the 7th of the month, if C2 is between 8 & 14, then 14, C2 is between 15 & 21, then 21, c2 is between 22 and the last day of the month, then the last day.

1 reply


Take a look here:
https://support.office.com/en-us/article/Calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38

See if that isn't a good start for you. POst back if you are stuck!