I'm trying to auto populate a column with Monday to Sunday dates based on date from another column.

tgattsh

Example "Current Date" Column "01/08/24" "Week Of" column would auto populate "01/08/24 - 01/14/24"

Current Date / Week Of

01/08/24 / 01/08/24 - 01/14/24

01/09/24 / 01/08/24 - 01/14/24

01/10/24 / 01/08/24 - 01/14/24

~

01/15/24 / 01/15/24 - 01/21/24

Paul Newcome

Sorry about that. Had an errant piece still floating around.

=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + " - " + ([Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + 6)

Paul Newcome

Try this:

=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + " - " + (=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + 6)

tgattsh

@Paul Newcome Thank you so much for your reply! Unfortunately I get an #INVALID OPERATION.

Any further suggestions would be greatly appreciated sir...

Paul Newcome

Sorry about that. Had an errant piece still floating around.

=[Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + " - " + ([Current Date]@row + (2 - WEEKDAY([Current Date]@row)) - IF(WEEKDAY([Current Date]@row) < 2, 7, 0) + 6)

tgattsh

To say AWESOME would be an understatement! Thank you @Paul Newcome ...

Paul Newcome

Happy to help. 👍️