| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MonthName to Integer from Current to Previous Year
Do something like
dt = Date m = Month(dt) m = m - 4 If m <= 0 Then m = m + 12 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "nerbe" wrote in message ups.com... Sorry. I should have clarified... The way I am currently calculating this is essentially 4-7 = -3. That is, (April 2006) - (7 months) = October 2005 October is the 10th month of the year, but in doing the math the way I am currently doing it, I get a negative number -- a number that does not correspond to a month 1 thru 12. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want previous years data to drop off as I enter current year data | Charts and Charting in Excel | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| Calculating monthly totals for current and previous year | New Users to Excel | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
