How would I do this in excel (making a julian date calculator type of thingy)

[88keys]

I'd imagine this is possible but I have no idea where to start and I can't seem to find the right answer in google so here it goes.

Basically what I want is for it display a date range in both traditional and julian formats in rows 3 and 4 respectively based on the date entry in cell A1 (Sunday December 5th 2015)

The cells have all been formatted to display the dates as they are shown.

And for what it's worth, a Julian date is basically the day of the year (i.e. December 6th is the 341th day of the year. January 10th is the 10th day of the year).

Julian dates are generally the same each year with the exception of leap years for obvious reasons. So for this reason I guess that I'd need to create a table for it to refer to unless there is a way for excel to calculate for that too....

Thanks in advance.

 

[lxskllr]

You should be using the Discordian calendar.

Today is Pungenday, the 51st day of The Aftermath in the YOLD 3181

 

[Puffnstuff]

Here's a formula and you'll probably have to nest several commands in order to bring the data to a particular cell. http://www.cpearson.com/excel/jdates.htm

 

[88keys]

Thanks. That worked very well and it was much more simple than I thought.

Basically I kinda cheesed it up by onlu calculating a julian date in cell A4 based on the date entered in A1 and then just adding 1,2,3 for each additional day of the week based on calculation in A4.

The traditional dates displayed above are done in a similar manner.

But it all works and even knows to adjust for leap year.

 

[Charlie98]

Julian dates are the last number of the year followed by the numerical date... like, in your example, 6DEC 2015 would be 5341. At least that's how we did it in the Army...

 

[Ken M]

The earth is only 6,000 years old. Everybody knows this.