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?
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