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

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
 
S

ShaneDevenshire

Hi,

Yes, I just confirmed this issue! I also tested in 2003 and it is not
happening there.
 
D

Devo Clubber

Thanks for confirming this, i thought i was going mad!!

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

Regards

Steve
 
J

JE McGimpsey

I see it too.

FWIW, it doesn't occur in WinXL2003, nor in MacXL2008, or MacXL2004
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't get simple chart to look right 3
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
NETWORKDAYS including Saturdays 21
Excel 2000 - Help with Countif needed 2
show the date when it is later than today's date 4
Find then highlight in yellow 6
Excel Chart SeriesCollection Formula 1
How to get the first day of the previous month... 2

Top