Formula

T_Miranda

Hello,

Can someone help convert this excel formula to SS? 

=IF([DAY COUNTER]1 = "1", =TODAY(), IF([DAY COUNTER]1 = "2", =TODAY() + 1, IF([DAY COUNTER]1 = "3", =TODAY() + 2, [DAY COUNTER]1)))

Expected result is to determine that 1 = current date, 2 = current date+1, 3= current date+2

I'm not sure if I'm explaining it correctly but hoping someone can help this newbie.  Much thanks!

 

SYSPK

Try the formula again but remove the equals sign in front of every TODAY().

Frank Falco

You could also change TODAY()+1 to TODAY(1), likewise for the +2 TODAY(2) etc

TODAY([number])

• number—[optional] 

  The number of days before (negative number) or after (positive number) the current date.

T_Miranda

Thank you very much! 

T_Miranda

Thank you very much!