Now() formula not recognised

**deviaug28** · 02-27-2013, 05:24 PM

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

**alansidman** · 02-27-2013, 05:25 PM

Suggest you post your sheet. Easier to work with actual data versus theorize.

**deviaug28** · 02-27-2013, 05:29 PM

Here you go..

**alansidman** · 02-27-2013, 05:41 PM

Here is a simpler solution
Replace your nested if statement with this =VLOOKUP(E1,$A$2:$C$17,3,TRUE)

BTW: Your formula works fine on my machine. Do you have your calc set to manual?

Also it is still 2/27/2013 in US.

**popipipo** · 02-27-2013, 05:49 PM

Use today() instead of now()
now()+1 =28 feb 2013 22:00
Column B8 = 28 feb 2013 00:00:00
now()+1 ls later than B8 an earlier as A9

I should use
=IF(E1>MAX(A2:B17);"No Quarter Match Found";VLOOKUP(E1;A2:C17;3;1))

**deviaug28** · 02-27-2013, 05:49 PM

Thank you Alan. Vlookup formula works great. No. I have calc set to automatic only. I have even tried changing the date in my peer's system(sitting in US) to 2/28/2013 and she too has the same issue. It does not work only on 2/28/2013. As if now, i can go with the vlookup formula. I am just worried if this going to affect my other reports.