| 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 |
| 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 | |||
Threaded Mode
