One Day Out when Using EoMONTH in 1904 Date System : Excel 2007

  • Thread starter Thread starter Devo Clubber
  • Start date Start date
D

Devo Clubber

Is anyone else experiencing this issue when using 1904 Date System within
Excel 2007? The date it returns appears to be one day less than it should
be!!!

=EOMONTH(c1,-1) return 29/09/2008 rather than 30/09/2008
a B
C
1 =EOMONTH(c1,-1) 29/09/2008 01/10/2008
2 =EOMONTH(c2,-1) 30/10/2008 01/11/2008

It seems to be the same for all dates when using this system, but works ok
when using the normal default date system it work OK.

Is this a known bug?

Regards


Steve
 
Hi,

Yes, I just confirmed this issue! I also tested in 2003 and it is not
happening there.
 
Thanks for confirming this, i thought i was going mad!!

Does anyone know how i go about reporting this bug to Microsoft?

Regards

Steve
 
Back
Top