Navigating Worksheets

[nniedzielski]

I have a workbook where I have worksheets that are titled by date in this format: "14-Dec"

I am able to use this code to find todays date:

Worksheets(Format(Date, "dd-mmm")).Select

and I use these to go back a day or forward a day from todays date:

        ActiveSheet.Next.Select
        ActiveSheet.Previous.Select

Is there a way to go forward or backwards multiple days by using a -2 or a +2 anywhere in the line of code? Ideally I would like to be able to find the sheet for today and go back 5 days.

thank you,

 

[JoeMo]

Maybe:

Worksheets(Format(Date-5, "dd-mmm")).Select

for 5 days prior to today.

 

[Tetra201]

How about

Worksheets(Format(Date[COLOR=#ff0000]-5[/COLOR], "dd-mmm")).Select

 

[nniedzielski]

that was the only place i didnt try to do the math, thanks guys

 

[Tetra201]

You are welcome.