| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| average value from a table | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| & reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Linear Mode
