Now() formula not recognised

[deviaug28]

Hi All,

I am facing a strange problem in my excel sheet. I have '=Now()' formula in a cell and i have a IF formula which refers to the values of '=Now()' and provides result. If formula is not recognizing the value of today's date(2/28/2013) only. If i change the system date to other dates(except for 2/28/2013), it works fine. I have checked with few of my peers in different timezone and they too face the same problem. Any thoughts? Is this have anything to do with my excel settings? Sorry if i am confusing, i can post the excel sheet if required.

Appreciate your assistance.

Regards,
Kiruba

[TMS]

i can post the excel sheet if required

Yes please

Regards, TMS

[alansidman]

OP has posted in two locations.
http://www.excelforum.com/excel-form...92#post3139592

[TMS]

Thanks Alan

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.