I am a little confused how this works..
Here is my example:
Cell E3 =TEXT(DATE(2014, 1, 1)+(COLUMNS('JA Q1'!$A:D)-1)*14+19, "mm/dd/yy") =03/03/2014
Cell E4 = 60.00
Cell E5 = 80.00
Cell E6 =IF(E3>=TODAY(),E4-E5,0) =(20.00)
So basically in cell E6. Why is this returning (20.00) if my statement is greater than or equal to today's date which is 05/27/2015? Should it be returning 0?
Thanks in advance,
Andrew
Here is my example:
Cell E3 =TEXT(DATE(2014, 1, 1)+(COLUMNS('JA Q1'!$A:D)-1)*14+19, "mm/dd/yy") =03/03/2014
Cell E4 = 60.00
Cell E5 = 80.00
Cell E6 =IF(E3>=TODAY(),E4-E5,0) =(20.00)
So basically in cell E6. Why is this returning (20.00) if my statement is greater than or equal to today's date which is 05/27/2015? Should it be returning 0?
Thanks in advance,
Andrew