If this date, than that date formula

Options
Christopher Newhook
edited 06/23/22 in Formulas and Functions

I am seeking a formula that takes a date from one column and populates a weekday date in another cell 45 days later, or 90, or....however many I indicate. Ideally, the said "then" date will be a day during the weekday, if possible, but it's not a deal-breaker.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @Christopher Newhook

    Example sheet:

    # of Days To Add column is just a dropdown with options for 30, 45, and 90 but you can add what you want to it.

    Forecasted Date formula:

    =[Original Date]@row + [# Days To Add]@row

    Day of Week formula:

    =WEEKDAY([Forecasted Date]@row)

    Final Date formula:

    =IF([Day of Week]@row = 1, [Forecasted Date]@row + 1, IF([Day of Week]@row = 7, [Forecasted Date]@row + 2, [Forecasted Date]@row))

    Then you can hide the columns called Forecasted Date and Day of Week.

  • Christopher Newhook
    Options

    Awesome - thanks, Mike TV!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!