in reply to Converting Julian Dates to Text

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.

--
John.

In Section Seekers of Perl Wisdom