If this date, than that date formula

Christopher Newhook

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.

Mike TV

@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

Awesome - thanks, Mike TV!!