Macro Question

[siafc1]

Can somebody please tell me the necessary macro to add one week to whatever date is in cell B11 of sheet4?

Thanks

 

[tusharm]

XL (or VBA for that matter) stores date-time as numbers with the whole part (to the left of the decimal point) representing the date and the fraction part the time (24 hours). The date part is simply the number of days since an arbitrary starting point. So, given that a week is 7 days, a week after a particular date would be...

 

[siafc1]

"arbitrary starting point" + 7

I don't know how to create a macro that does that though. I know it's probably very simple. I'd be grateful of the code I'd need to create that macro.

 

[Legacy 12630]

It would appear that Tusharm's Socratic approach failed, so :-

Sub Add_Seven_Days()
Sheets("Sheet4").[B11]=Sheets("Sheet4").[B11]+7
End Sub

 

[siafc1]

Perfect, thanks ponsonby :wink: