Fprmula to count date with 2023 as year

Options

Hi


im trying to add the week number only for projects with 2023 dates. the below only counts all week number but doesn’t distinguish between year. can you help


=WEEKNUMBER([ACTUAL - Site Acceptance Completion Date]1)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!