How to get the current week Dates Dynamically

Shaik. Baru
Shaik. Baru ✭✭✭
edited 12/13/23 in Formulas and Functions

Hi there,

I've created a user level Timesheet, where users have access to update their Timesheets on weekly basis. User wants to see the current week Dates.(Eg; Wk 50 "Mon 11Dec - Fri 15Dec")

Please find the below screenshot for reference. I've tried using today's date formula, somehow it shows the next week dates. Is there any way to show the current week dates dynamically?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!