Date Reference Oddity
 

Why when i use =MONTH(B15)

to call the month into a seperate cell does it always (regardless of
formatting) put the month in the days column

eg. if the formatting is dd.mm.yy

if the date is 02.05.06
the reference will invariably return 05.01.00



?????????????????????????????????????????????????? ??????????????????????


what on earth am i doing wrong????


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=545125

Date Reference Oddity
 

Format as general. not as dates


Regards,


Peo Sjoblom


"duncan79" wrote:


Why when i use =MONTH(B15)

to call the month into a seperate cell does it always (regardless of
formatting) put the month in the days column

eg. if the formatting is dd.mm.yy

if the date is 02.05.06
the reference will invariably return 05.01.00



?????????????????????????????????????????????????? ??????????????????????


what on earth am i doing wrong????


--
duncan79
------------------------------------------------------------------------
duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=545125

Date Reference Oddity
 

"duncan79" wrote in
message ...

Why when i use =MONTH(B15)

to call the month into a seperate cell does it always (regardless of
formatting) put the month in the days column

eg. if the formatting is dd.mm.yy

if the date is 02.05.06
the reference will invariably return 05.01.00

what on earth am i doing wrong????

The result of your formula is 5. You've formatted it as a date when it
should be a number.
--
David Biddulph