How to increment a date by one day across multiple sheets

[mmelki]

Hello,

I am new to VBA in excel.
I have a workbook with 15 sheets.
I want to insert a date in cell B4 on sheet 1, and have all dates in sheets 2 to 15 incremented by 1 day.
example sheet 1: date: 29/07/2015
sheet 2: date: 30/07/2015
sheet 3: date: 31/07/2015
sheet 4: date: 01/08/2015

Also, I want cell Z4 in each sheet to be updated with the matching day of the date
example sheet 1: day: Wednesday
sheet 2: day: Thursday
sheet 3: day: Friday
sheet 3: day: Saturday

Can you please help me?

[cbatrody]

Hi,

Yes, you just have to use =Sheet1!B4+1 on Sheet2!, Sheet2!B4+1 on Sheet3! and so on...

and for date to be displayed as day in Z4 = TEXT(B4,"dddd")

[rajeevoli]

For VBA Code please let us know do you have different names of sheets or you have default names?