| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
i monitor every tuesday and thursday xls now need next months
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
i monitor every tuesday and thursday xls now need next months
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 "tutorisland" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1st and 3rd Thursday formula | Excel Discussion (Misc queries) | |||
| Display Monday or Thursday | Excel Worksheet Functions | |||
| how do i set date as 1st thursday of every month | Excel Worksheet Functions | |||
| Populating an excel calendar - eg. 10x tuesday/thursday from date x | Links and Linking in Excel | |||
| Message Box to appear Thursday midday! | Excel Worksheet Functions | |||
Linear Mode
