Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date plus 1 year, but begin of month
Hi Everyone,
I have the formula below to give me date plus 1 year, however I want to have this stated as the 1st of the month. Ex) D18= Dec 21/05, then result now is Dec 21/06, I want Dec 1/06. =MIN(DATE(YEAR(D18)+1,MONTH(D18)+{0,1},DAY(D18)*{1 ,0})) Also - does anyone have a resource in which I can learn about the purpose of the {} in the above formula, I just copied it from this site and haven't found any information as to why/how it works. Thanks in advance! ~Jessica |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date plus 1 year, but begin of month
You don't need the array constants in your formula
=DATE(YEAR(D18)+1,MONTH(D18),1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jessica" wrote in message ... Hi Everyone, I have the formula below to give me date plus 1 year, however I want to have this stated as the 1st of the month. Ex) D18= Dec 21/05, then result now is Dec 21/06, I want Dec 1/06. =MIN(DATE(YEAR(D18)+1,MONTH(D18)+{0,1},DAY(D18)*{1 ,0})) Also - does anyone have a resource in which I can learn about the purpose of the {} in the above formula, I just copied it from this site and haven't found any information as to why/how it works. Thanks in advance! ~Jessica |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
how to insert month date year and day of week | Excel Worksheet Functions | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
counting date entries by month & year | Excel Worksheet Functions |