Windows Forum

Ask something
Discussion Locked

Convert Julian Date to a regular Date

0 helpful
2 replies

by cheldt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Excel spreadsheet that has Julian Dates. How do I convert the Julian Date into a regular date? For example 2005270 = 9/27/05. OR
I have a dates (example '42001') that I'm trying to convert to a regular date 4/20/01. When I change the cell to a date field, I get 12/28/14.

Thank you

2 replies

by thechas

Your existing cell contents are not true Julian Dates.

Further, Excel does not store dates as Julian numbers. Excel uses a serial number to represent date and time. That is why when you change the cell format to date with your coded date, you get a seemingly random date.

I recommend that you treat your date field as a string and perform string functions to change the data to the format you desire.

Then, you can copy the cell data to a new cell and change it to a true date field.

The box I am on right now does not have Excel on it, or I would go through the specific commands.

I know that the commands are different in Quatro Pro.

Chas

This discussion is closed to new replies.