Fprmula to count date with 2023 as year

Paul Molloy

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)

Andrée Starå

Hi @Paul Molloy

I hope you're well and safe!

Try something like this.

=IF([ACTUAL - Site Acceptance Completion Date]@row = "", "", IF(YEAR([ACTUAL - Site Acceptance Completion Date]@row) = 2023, WEEKNUMBER([ACTUAL - Site Acceptance Completion Date]@row)))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Molloy

Hi @Andrée Starå

it did work. thanks you for your help, very much appreciated.

Thanks

Andrée Starå

@Paul Molloy

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!