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
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.
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:
- IF Function Using a Date Range
- Accessor function c++ - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Network card function - Guide
- If function with date range - Guide
1 response
Take a look here:
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38?ui=en-us&rs=en-us&ad=us
See if that isn't a good start for you. POst back if you are stuck!
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-dates-8235e7c9-b430-44ca-9425-46100a162f38?ui=en-us&rs=en-us&ad=us
See if that isn't a good start for you. POst back if you are stuck!