Weekday Formula

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

  • 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

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

  • Susan Wu
    Susan Wu ✭✭

    Hi!

    Thank you for your input. I figured it out


    Cheers,

    Susan

  • Great! Glad you figured it out πŸ™‚

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!