Excel 2007 : Auto Populating payroll deadlines calculator

[mcinnes01]

Hi,

I am looking for a way to build an auto populating calculator for a payroll department. Essentially every month their are various deadlines which depend on for example the pay day being on the last working day of the month, the bacs transfer day being 2 working days before this and so on.

I want the excel calendar to display months down the left and the various deadlines across the top. Then It will have three criteria to compile the calendar start date (year/Month) and then end date (Year Month).

From this it will then complete the lay as in my example file attached...

I have created a calendar macro allready as per: http://www.fontstuff.com/vba/vbatut07.htm

and this is working other than the code to remove the new short cut menu item when i close. any help on that would also be appreciated!

I'd like to use this function to enter the start and end dates.

The sheet will also need some logic in to make sure the end date is not before the start date.

Any help would be great, p.s. i'm ok with excel but please don't make any assumptions treat me as a noob!

Thanks,

Andy