IF Function Using a Date Range [Closed]

Question

IF Function Using a Date Range [Closed]

Report

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.

IF Function Using a Date Range
If function in excel date range - How-To - Excel
Excel If Function over a range of dates - How-To - Excel
If function in data range ✓ - Forum - Office Software
Excel If Function over a range of dates ✓ - Forum - Excel
Function of spreadsheet - Articles

1 reply

Ask a question

Blocked Profile · Answer 1 · 2017-12-21T14:38:06-0500

Answer 1 / 1

Blocked Profile
Dec 21, 2017 at 02:38 PM

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!

IF Function Using a Date Range [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!