Weekday Formula

Options
Susan Wu
Susan Wu
edited 04/17/20 in Formulas and Functions

If today is Thursday, 04/16/2020. How do I get the Weekday function to calculate a future Wednesday date instead of Wednesday, 04/15/2020?

I have tried using:

(Date 1) - (Weekday(Date 1)-4)

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi Susan,

    The WEEKDAY function returns a number to represent a day of the week. In this instance, your WEEKDAY formula would have found the number 5, because Date1 is a Thursday. This means that essentially your formula is saying this:

    04/16/2020 - (5 - 4)

    Which is removing one day from your current day. To find the next Wednesday from a Thursday you could simply add 6 days to to date, like so:

    =Date1 + 6

    (Click Here for an article on how to use dates in formulas)

    However if your dates in the Date column will be different days of the week, and you always want it to return a Wednesday in the other column, we'll have to build something a little bigger. Would you mind clarifying what you're looking to do, more than just this one instance? A screen capture of your sheet would be very helpful, but please block out any sensitive data.

    Thanks!

    Genevieve

  • Susan Wu
    Options

    Hi!

    Thank you for your input. I figured it out


    Cheers,

    Susan

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Great! Glad you figured it out 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!