A Amit Kumar Baidyaka Jan 3, 2008 #1 Hi, Can someone help me with how to change a date (mm:dd:yyyy) into its julian date?
P poorboys Jan 3, 2008 #3 Create a cell with 12/31/07- todays date=julian date example below 12/31/06 - 10/27/07 =300 next cell beside it is =year reads 300 07 Production Date: Saturday 27-Oct-07 Code Date: BH 300 2007 12/31/2006
Create a cell with 12/31/07- todays date=julian date example below 12/31/06 - 10/27/07 =300 next cell beside it is =year reads 300 07 Production Date: Saturday 27-Oct-07 Code Date: BH 300 2007 12/31/2006
