IF Function Using a Date Range [Closed]

Registration date
Thursday December 21, 2017
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:

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