Using the example - Here is what I have been trying to do, in the fiscal year which normally starts in October and Ends in November - When the date reaches almost a year (in this case Oct-Nov) for the name of the person , including whether its pistol and riflle date to show up in another sheet.

The same goes for calender date (Which is Jan-Feb) when the date reaches a year for the name and whether this person is due for "BST, PFT, GAS CHAMBER and SWIM QUAL to be put on that same page..

Sounds extensive to me but to some of you GURUS out there its probably a piece of cake....