Date formatting Help

  • Thread starter Thread starter Db1712
  • Start date Start date
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
 
To get next Sunday's date, just add 7 to this Sunday. So something like:
cell.value + 7
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding days from one cell with a date in it to another cell 3
Conditional Formatting Dates 5
Counting calendar Days - not including Sundays 3
How to split a cell diagonally? 2
Conditional format using dddd 3
Calculating dates to include Saturdays but not Sundays 1
CALENDAR CREATION 1
Formula for adding a day to a particular date. 1

Back
Top