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

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