Weekday Formula

Susan Wu

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)

Genevieve P.

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

Hi!

Thank you for your input. I figured it out

Cheers,

Susan

Genevieve P.

Great! Glad you figured it out 🙂