custom dates in workbook

[Sarjent]

I have an excel spreadsheet that I need to autofill dates in. Its a little tricky.
The dates are for when we do patching of systems.
The start date is the 2nd tuesday of the current month
Additional dates to list would be
+2 days
+3 days
+4 days
+6 days
+9 days
+10 days
+11 days
3rd Saturday of the current month
4th Saturday of the current month
1st Saturday of the NEXT month

I have no idea where to even begin so any help would be great. I'd also like that sheet to update on open. All I need to display would be the date itself.

Thanks

 

[Domski]

Hi,

For the +? days you can just use =A1+2, A1+3 etc.

For the Saturday's I've seen a few posts along similar lines before. If you do a search I'm sure you'll find what you're after.

Dom