Date plus 1 year, but begin of month

J

Jessica

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
 
B

Bob Phillips

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)
 
Top