Leap Year and Julian Date formulas

TiggerToo · Mar 13th, 2002, 07:51 PM

I need and updated type formula for for Julian Dates, where I can type in a julian date and get the date plus the day of the week, or vice verse.
Like 2060 would be Mar 1, 2002

I also need an updated formula for Leap Years such as iif I put in a date at anytime of a year JUN 10, 1999 instead of telling me, No - Not a leap Year I would like for cell to tell me when is the next leap year.

JUN 1999 the next cell would should 2000
MAR 2002 would show 2004.

[ This Message was edited by: TiggerToo on 2002-03-13 13:54 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Mar 13th, 2002, 07:51 PM	#1
TiggerToo Join Date: Feb 2002 Location: Macon, Georgia USA Posts: 116	I need and updated type formula for for Julian Dates, where I can type in a julian date and get the date plus the day of the week, or vice verse. Like 2060 would be Mar 1, 2002 I also need an updated formula for Leap Years such as iif I put in a date at anytime of a year JUN 10, 1999 instead of telling me, No - Not a leap Year I would like for cell to tell me when is the next leap year. JUN 1999 the next cell would should 2000 MAR 2002 would show 2004. [ This Message was edited by: TiggerToo on 2002-03-13 13:54 ]