Week number formula

Paul Molloy · 04/22/22

Hi

I want to search the week but also only 2022 weeks as my sheet also has 2021 and i don't wish to display those.

This is what i have today

=WEEKNUMBER([Project Actual Completion Date]@row)

Thanks for your help

Jeff Reisman · 04/22/22

Use an IF formula and use the YEAR function to specify the year:

=IF(YEAR([Project Actual Completion Date]@row) = 2022, WEEKNUMBER([Project Actual Completion Date]@row), "")

If the year in the Project Actual Completion Date field equals 2022, show me the week number for that date, otherwise leave the cell blank.

Jeff Reisman · 04/22/22

Use an IF formula and use the YEAR function to specify the year:

=IF(YEAR([Project Actual Completion Date]@row) = 2022, WEEKNUMBER([Project Actual Completion Date]@row), "")

If the year in the Project Actual Completion Date field equals 2022, show me the week number for that date, otherwise leave the cell blank.

Paul Molloy · 04/22/22

Hi Jeff

😀

thank you for your help. it works perfectly.

have a great weekend

Jeff Reisman · 04/22/22

Happy to help!

Best Answer