G Guest Mar 17, 2006 #2 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)
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)
