Help with Weeknumber function that takes into consideration years.

I would like to do a if Statement

I have a column called "Date" w/ a Date

I have a column called "Health" which is a color (red,yellow)

I would like to do a formula in my Health column

If "Date" is Next Week then "Health" = Yellow

If "Date" is Last Week then "Health" = Red

Requirements

-I would like to not count by days.. as that is different result.

-I would like it to work across different years

for example

if today is Dec 1 2022 and Date = Jan 1 2023

if today is Jan 1 2023 and Date = Dec 1 2022

In summary...

It should function like WeekNumber function but take into account Years.... basically.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!