| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Serial number of Date
Hi All, Can anyone tell me why my formula =datevalue(A1) returns #Value when the contents of A1 are 13/01/2005. When I am converting 12/01/2005 the formula works. I think its something to do with the US/UK version of expressing dates but I cant work out how to fix it! Regards Garry -- Gazzr ------------------------------------------------------------------------ Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075 View this thread: http://www.excelforum.com/showthread...hreadid=525986 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time serial number | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
| & reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Threaded Mode
