Formatting a workbook with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with five worksheets representing the days of the week
(M-F). I want to able to enter the date on the first worksheet (Monday) and
have the correct following date be automatically inserted onto each following
worksheet for that week.
 
You can use a formula

=IF(A1="","",A1+1)

where A1 holds the 1st date, the formula will add 1 to the date
if you set it up nicely you should just be able copy the formula across/down
and it will
increment by one, otherwise you can copy a cell using right click mouse and
when you release it you'll be prompted to select for instance weekdays, it's
not automatic but easy and fast



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

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

Want to keep 'historical' data using formulas 2
Sequential dates across worksheets 4
Merge Multiple workbook sheets into one workbook 0
Independently controlled dates on each worksheet 2
Worksheets in a formulae 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
auto date changing on worksheets 8
How 2 change date in 1 cell/worksheet so it changes in all workshe 2

Back
Top