| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
End of month in the future..
Question.. a document expires in the end of month, 5 years ahead. How do I
get this result from the start date? A1 ... Start date mm/dd/yyyy A2 ... (Due date) doc expires end of month, 5 yr from start |
|
#2
|
|||
|
|||
|
=DATE(YEAR(A1)+5,MONTH(A1)+1,0)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Kane" wrote in message ... Question.. a document expires in the end of month, 5 years ahead. How do I get this result from the start date? A1 ... Start date mm/dd/yyyy A2 ... (Due date) doc expires end of month, 5 yr from start |
|
#3
|
|||
|
|||
|
Thanks Niek ... just what I needed! Have a nice day... Kane
"Kane" wrote: Question.. a document expires in the end of month, 5 years ahead. How do I get this result from the start date? A1 ... Start date mm/dd/yyyy A2 ... (Due date) doc expires end of month, 5 yr from start |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
Linear Mode
