I'm trying to auto populate a column with Monday to Sunday dates based on date from another column.
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
Best Answer
-
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)
Answers
-
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)
-
@Paul Newcome Thank you so much for your reply! Unfortunately I get an #INVALID OPERATION.
Any further suggestions would be greatly appreciated sir...
-
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)
-
To say AWESOME would be an understatement! Thank you @Paul Newcome ...
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!