(a) how does this help with the question asked, as NOW gives todays
date
(b) in the original question, we may very well need date serial as this
stops Excel mis-interpreting the date - I'm in the UK and I can promise
you that from VBA Excel DELIGHTS in assuming I meant an American date
if it could possibly interpret it that way - DateSerial stops that from
happening!