Date formatting Help

D

Db1712

Macro - Help
How can you select a cell with a Sunday's Date to give you th
following Sunday's Date when execute
 
F

Fred Smith

To get next Sunday's date, just add 7 to this Sunday. So something like:
cell.value + 7
 
Top