The stupid question is the question not asked | |
PerlMonks |
Re: Converting Julian Dates to Textby jmcnamara (Monsignor) |
on Nov 03, 2008 at 12:41 UTC ( [id://721080]=note: print w/replies, xml ) | Need Help?? |
The unformatted date in Excel appears to be in the Julian format.
Dates in Excel are not stored in Julian format. They are stored as the number of days from a 1900 epoch with 1900 treated as a leap year. Both WritExcel and ParseExcel provide utility functions for dealing with dates in this format but I'd recommend the DateTime::Format::Excel module.
--
In Section
Seekers of Perl Wisdom
|
|