If posted before please direct me to the post.
I hope I can explain this clearly. I am experienced but not an expert in
excel.
I have 24 worksheets in 1 workbook for 24 months. We use it as our duty log
for each month. I am trying to figure a way to calculate dates for the
preceding 60/90/180 days from the current Day. Currently I have it just
figuring the preceding 3/6 months or 12 months. The days are just listed in
Col 1 starting at Row 9 as 1, 2, 3...31 in that column. Should I change
those to Dates/Days and if so Is there a way to have them show just the
1,2....31 ...
Also when 2006 comes around I will be making new workbooks for the new year
instead of adding another 12 into the current file. Can the new workbook be
linked to the old data and if so how?
I know this is alot to ask for but again when it comes to the advanced
functions I am a rookie.

Now with all that said. If it would be easier for someone to help by seeing
the file. Please email me at
brianbranch at sbcglobal.net
and i would be happy to send it to you.

Thanks ALOT in advance for any help.

Brian Branch
Halo FLight Inc.
Non-Profit Air Ambulance Service
Corpus Christi, Tx