| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Autofill Showing Mondays ONLY in a calendar year
S1,
Type in the date of the first Monday that you are interested in, say, in cell A2. Then in the cell below (A3) use the formula =A2+7 then copy that down for another 50 rows. HTH, Bernie MS Excel MVP "S1" (donotspam) wrote in message ... Can someone share how I can use autofill, or any other formula to start on a monday, and only show every monday (52 for the year) as the begining of each week? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
| How would I make a calendar template in Excel for the year 2006?? | Excel Worksheet Functions | |||
Threaded Mode
