Hi all,
I'm trying to use this code for a countdown timer for paydates. What I want it to do is calculate if today is before the next pay date, to put the amount of days between today and payday. I was trying to use an IF statement and put in all the paydates for the year.... but all I get is FALSE result.
=IF(TODAY()<8/6/2012,8/6/2012-TODAY(),IF(TODAY()<6/7/2012,6/7/2012-TODAY(),IF(TODAY()<3/8/2012,3/8/2012-TODAY(),IF(TODAY()<31/8/2012,31/8/2012-TODAY()))))
Any help would be appreciated! Thanks.
Gary
Bookmarks