I believe the DATE function has to be in the syntax (year, month, day)
Try:
=IF(BG11<DATE(2011,11,16),"Past due",IF(BG11>DATE(2011,12,16),"Current","Within a month"))
I believe the DATE function has to be in the syntax (year, month, day)
Try:
=IF(BG11<DATE(2011,11,16),"Past due",IF(BG11>DATE(2011,12,16),"Current","Within a month"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks