I Posted this question yesterday and got one reply but it didnt completely
help due to me not completely explaining myself or maybe not putting enough
info here. I hope this repost will help with getting a better answer.

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 Total times for the
previous 60/90/180 days from the current Day. Currently I have the cells
figuring the preceding 3/6 months or 12 months from the prior sheets cells.

COL A Col B-Z have other data including Flight Time, Day / Night NVG ect
Day
1 <--- Row 9
2
3
4
5
6
....31 <---- Row 39


Row 40 Has Sums of Times from above rows where it applies for the month
Row 44 has Quarterly Totals and Row 46 has Annual Totals


The days are just listed in Col 1 . The month is listed in Row H4 in a Pull
down list. Should I change those to Dates/Days using the Day Function?

I know this is alot to ask for and might be confusing 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 actual file. Please email me at

brianbranch at sbcglobal.net

and i would be happy to send it to you. I am sure if you could see the file
you might even have other suggestions for me on how to automate alot more of
the functions I have.

Brian Branch
Halo FLight Inc.