Formula to assign phase based on a date

Melissa Torrez

I am trying to build a formula that determines if Start and/ or Finish date are equal to "Day 1", "First 100 Days", or "100+ Days" by looking at a specific date field and it will ultimately return in the "Phase" column:

"Day 1"

"First 100 Days"

"100+ Days"

Heather_Verde

So you need to determine what date you are vetting the Start Date or Finish Date against. Are you looking to compare the Finish date to the Start date? If you are comparing the Finish Date to the Start Date, then this formula should work

=IF(End@row = Start@row, "Day 1", IF(End@row - Start@row <= 100, "First 100 Days", "100+ Days"))

Otherwise, determine the date you want to use as your base date for comparison and plug it into the formula accordingly.