Date Reference Oddity

Giganews Newsgroups
Subject: Date Reference Oddity
Posted by:  duncan79 (duncan79.28bijm_1148484326.4076@excelforum-nospam.com)
Date: Wed, 24 May 2006

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?action=getinfo&userid=30833
View this thread:http://www.excelforum.com/showthread.php?threadid=545125

Replies