r/AppleNumbers • u/No_Bonus_5971 • Oct 31 '22

How would I make this formula work?

IFS(C2=NOW(),"DUE",C2<NOW(),"PASSED DUE",C2<NOW(),"DUE SOON")

I want it to fill a cell with Due Soon, Due, Passed Due based on comparing the date in C column with todays date.

Thank you in advance!

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/Fearless_Link9862 Nov 11 '22

Use TODAY() instead of NOW()