IF function to return value based on dates

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"

=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

Find more posts tagged with

Formulas

functionality

IF(OR

IF(

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.