| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Giving Months Numerical Values
Hi
With an Excel date in A1, =Month(A1) will return the Month number To make it an offset from November, it would be =11-MONTH(A1) Regards Roger Govier luvthavodka wrote: I have a spreadsheet containing data over various numbered weeks. From this I use VLookup to produce a graph showing the data from the last 13 weeks. Each time the current week number is updated, the last 13 weeks change in turn. On the same spreadsheet I also keep the data by month. I now want to use a similar VLookup to produce a graph showing the last 6 months. How/Is it possible to give eg November a numerical value so the other rows are eg November-5 (June) November-4 (July) etc? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| View of x-axis values | Charts and Charting in Excel | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Scatter chart without numerical values | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Hybrid Mode
