| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to/from Excel date
Is there any code or an article that lists exactly how to convert to/from a
datetime as stored in an Excel XLSX file and year/minth/day/hour/minute/second? Also, from playing with it, it appears that Excel thinks 2/29/1900 existed (it was not a leap yer). -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to convert solar date to lunar date using excel? | Excel Discussion (Misc queries) | |||
| How to convert Gregorian date into Hijri Date in Excel 2007? | Excel Discussion (Misc queries) | |||
| VBA convert day and date from text string to Excel date | Excel Programming | |||
| Convert an Excel date to a date of my format in VBA | Excel Programming | |||
| how do I convert a UK date to a US date in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
