ExcelBanter - julian date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - julian date (https://www.excelbanter.com/excel-discussion-misc-queries/77959-julian-date.html)

jeff

julian date

how do i convert a julian date to a gregorian date in excel 97

Kevin B

julian date

The formula below would add your Julian date number to December 31 of the
prior year to produce a serial date number.

=DATE(YEAR(NOW())-1,12,31+A1)
--
Kevin Backmann

"jeff" wrote:

how do i convert a julian date to a gregorian date in excel 97

All times are GMT +1. The time now is 11:27 AM.