Automated due date for 2 "Saturdays" from request date?

Travis Griffin

I know you can automate dates with a command like this:

=[Request Date]1 + 21

That creates a date 21 days in future.

But our change windows are on Saturdays. Is there a way to do a similar formula to say, "automated due date is 2 Saturdays from a date?

John Jonassen

Try this:

=([Request Date]1 + (7 - WEEKDAY([Request Date]1)) + 7)

John Jonassen

Try this:

=([Request Date]1 + (7 - WEEKDAY([Request Date]1)) + 7)

Travis Griffin

Amazing! Thank you.

John Jonassen

You're welcome, @Travis Griffin . If you ever need this again, but for a different day of the week, just change the first 7 (before the Weekday) to the number that corresponds with the day of the week that you need. 1 being Sunday through to 7 being Saturday.