I am trying to create a calendar for inspections that occur every 180, 224, 336 and 448 days. In the Navy we use Julian Dates which are basically the day of the year(i.e. Jan. 1 = 001; Feb. 1 = 030).

I have this:

=INDEX(dayofyear+180,COLUMN(C12)-COLUMN($B$12))

and this allows me to calculate everything, but I also need the year to show in the chart, right now when I format the cells to show the date as 13-Feb-2007 it defaults to 1900. Somehow I need the formula above to show the year that is in (B5).

Any ideas? Am I explaining this well enough?

I use a scroll bar that you can move through the years with and the displayed year shows on (B5).

Any help would be great, even if it doesn't use Julian Dates. The old way is to take todays date, convert it to Julian, add 180,224,336 or 448 , subtract 365 if needed and then reconvert back into standard form.

Thanks in advance,
AZAA Johnson, USN

In case you wondered:
AZAA - Aviation Maintenance Administrationman Airmen Apprentice