| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating months
After entering "April" you can select the cell and drag the fill
handle in the bottom right corner across or down to fill months. If you want a formula though, try entering this: =TEXT(DATE(0,MONTH(A1&"-0")+1,1),"mmmm") in A2, and dragging down should, assuming the month is in A1. On Feb 6, 2:39 pm, hotelmasters wrote: If i have the name of a month in a cell (i.e. "April") can i then have another cell calculate itself to display the next or previous month automatically (ie. "May" or "March") by using a formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem of calculating years months and days | Excel Discussion (Misc queries) | |||
| Calculating months | Excel Discussion (Misc queries) | |||
| Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
| calculating number of months from today | Excel Worksheet Functions | |||
Hybrid Mode
