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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!