| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a month onto todays date
Frank Kabel wrote...
try =DATE(YEAR(A1),MONTH(A1)+1,MIN(DAY(A1),DAY(DATE(YE AR(A1), MONTH(A1)+2,0)))) .. Why not condense that to =A1+31-DAY(A1+31)+(MONTH(A1+31)-MONTH(A1)<2)*DAY(A1) Just a simple reason: I use this kind of formula also adding n months in the generic form of: =DATE(YEAR(A1),MONTH(A1)+n,MIN(DAY(A1),DAY(DATE(YE AR(A1),MONTH(A1)+n+1, 0)))) Of course one can adapt your formula also for more than 1 month but as I'm lazy I just stick to the above solution :-) But agreed your solution is shorter for adding 1 month |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding/omitting/all the values prior to todays date | Excel Worksheet Functions | |||
| Adding months to date at end of month | Excel Discussion (Misc queries) | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Adding a month to a date | Excel Discussion (Misc queries) | |||
| Adding month and year to form date | Excel Discussion (Misc queries) | |||
Hybrid Mode
