weeknumber formula

Yuval
Yuval ✭✭✭
edited 02/03/25 in Formulas and Functions

Hi,

In Israel our week starts from Sunday, therefore weeknumber formula calculates Sunday for previous week number. I use grid template and even on project template changing Sunday as week start, the formula "weeknumber" presents Sunday as previous week number, pls. see pic below.

How can I get Sunday as new weeknumber?

thanks

Yuval

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!