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
-I would like to not count by days.. as that is different result.
-I would like it to work across different years
if today is Dec 1 2022 and Date = Jan 1 2023
if today is Jan 1 2023 and Date = Dec 1 2022
It should function like WeekNumber function but take into account Years.... basically.
Help Article Resources
Check out the Formula Handbook template!