IF function to return value based on dates

Gina Prego

I am trying to get a value when I put in a particular date

If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or does it have to be between? For example

=IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return "Sprint 1"

OR

=IF([Target Completion Date]@row) is in month 8 then return "Sprint 1"

I want to keep going with month 9, month 10…etc. And if it is blank, return "BLANK

bisaacs

Hey @Gina Prego,

You should be able to use a formula like this:

=IFERROR(IF(Month([Target Completion Date]@row) = 1, "January Sprint", IF(Month([Target Completion Date]@row) = 2, "February Sprint, IF(Month([Target Completion Date]@row) = 3, "March Sprint, etc…))), "")

You should be able to chain this through all the months! You can use IFERROR to return a blank cell if the date is empty, or you can include an IF statement in the chain that reads:

IF(ISBLANK([Target Completion Date]@row), "")

Hope that makes sense!

Gina Prego

That didn't seem to help. So if my date is 6/15/2024 in the column Target Completion Date, I want to return "Sprint 1" on my column labeled Sprint. If my date is 6/29/2024 in the column Target Completion Date, I also want to return "Sprint 1" on my column labeled Sprint because it is in the month of June. If it is July 7 or July 15 or July 25, I want it to be Sprint 2. Target completion date is an actual date, not just a month. I hope this is a less confusing description