Originally Posted by Spencer101

Hi,

Have a look at the attached.

I've included a worksheet with an example for Excel 2003 and one for later versions as they use different formulas, although the 2003 version will work in later versions also.

I've added date cells to give a start date (and end date in the case of 2003).
You could hardcode the dates into the formula, but if you ever need to change the year and recalculate it's easier to change one cell than it is to change formulas.

Hope that's of help.
Let me know if I've misunderstood your requirement.

S.