LinkBack URL
About LinkBacks
aahh you didnt mention that the "12" was already in date format. try this...
=IF(NOW()<=DATEVALUE("9/"&DAY(E7)&"/2012"),"",IF(A!E8=TRUE,"P","N"))
aahh you didnt mention that the "12" was already in date format. try this...
=IF(NOW()<=DATEVALUE("9/"&DAY(E7)&"/2012"),"",IF(A!E8=TRUE,"P","N"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks