custom dates in workbook

Sarjent

New Member
Joined
Jul 14, 2004
Messages
41
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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,971
Messages
5,599,109
Members
414,289
Latest member
sonintebil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top