Adding to a date

socrjock

New Member
Joined
Nov 16, 2005
Messages
2
I write schedules for my team at work. Is there a way that I can input the start date of a week and let the function/formula do the rest? Also, is Excel smart enough to bump to the next month while doing this?
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Fat Cat

Active Member
Joined
Nov 5, 2004
Messages
336
If you have a date such as 10/10/2005 entered in say Cell A1, you can simply enter the formula =A1+1 into cell A2 and it will add 1 day onto the date in A1. Copy down for subsequent days and yes it will roll over to the next month/year etc
 

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,244
Members
412,709
Latest member
Rishu
Top