IF Function Using a Date Range

Closed
Morranda Posts 1 Registration date Thursday December 21, 2017 Status Member Last seen December 21, 2017 - Dec 21, 2017 at 02:26 PM
 Blocked Profile - Dec 21, 2017 at 02:38 PM
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.
Related:

1 response

Blocked Profile
Dec 21, 2017 at 02:38 PM
0