Need the Date of the beginning of the week.

ginamt3 · 10/25/22

how do I create a Week of Date based on dates during the week? For example the Delivery date of 10/21 I want populate the Week Delivery Date with the week number Date. Do I need to create and additional week number column or is there a formula I can use?

Screen Shot 2022-10-25 at 4.39.20 PM.png

Paul Newcome · 10/26/22

Make sure that the column you are putting the formula in is set to a date type column.

ginamt3 · 10/26/22

yep that was it! thank you.

Paul Newcome · 10/26/22

Do you mean the Monday of that week?

ginamt3 · 10/26/22

Yes

Paul Newcome · 10/26/22

Ok. And what happens for weekends? Does Saturday and Sunday go to the previous Monday or the following Monday, or are they split so that one goes one way and the other goes the other way?

ginamt3 · 10/26/22

Saturday and Sunday go to the previous Monday

Paul Newcome · 10/26/22

Give this a try:

=[Date Column Name]@row + (2 - WEEKDAY([Date Column Name]@row)) - IF(WEEKDAY([Date Column Name]@row) = 1, 7, 0)

ginamt3 · 10/26/22

I'm getting an error

Screen Shot 2022-10-26 at 10.56.43 AM.png

Screen Shot 2022-10-26 at 10.56.54 AM.png

Paul Newcome · 10/26/22

Make sure that the column you are putting the formula in is set to a date type column.

ginamt3 · 10/26/22

yep that was it! thank you.

Paul Newcome · 10/27/22

Excellent. Happy to help. 👍️

Need the Date of the beginning of the week.

Best Answers

Answers

Help Article Resources

Categories