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
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