Need the Date of the beginning of the week.

ginamt3

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?

Paul Newcome

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

ginamt3

yep that was it! thank you.

Paul Newcome

Do you mean the Monday of that week?

ginamt3

Yes

Paul Newcome

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

Saturday and Sunday go to the previous Monday

Paul Newcome

Give this a try:

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

ginamt3

I'm getting an error

Paul Newcome

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

ginamt3

yep that was it! thank you.

Paul Newcome

Excellent. Happy to help. 👍️