i monitor every tuesday and thursday xls now need next months

T

tutorisland

i have a bunch on companies on left
top has may-08 jun-08
under mos. 1 5 8...
under thu mon thur...

i need to get july, aug, sept...
must i input manual?
 
B

Bernie Deitrick

Enter a date in the first cell, like may 1, 2008, but format for custom d.
Then enter May 5, 2008 in the next cell, again, format for custom d. Then
in the next cell, use a formula like =D3+7 (where D3 is the cell with May1,
2008) and then copy that cell as far to the right as you need.

HTH,
Bernie
MS Excel MVP
 

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

Macro to insert rows at varied locations 0
Summarise data by Month 7
Month to Date cumulative totals 0
Moving numbers to different months 2
Referencing data across sheets 2
how do i set date as 1st thursday of every month 7
challenge! - match/index/lookup with multiple criteria 2
Stacked Bar Charting help needed 0

Top