Date plus 1 year, but begin of month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel Formula OFFSET maybe? 1
2 dimensional date sort 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
sumif for months and year 2
Getting MM-DD HH:MM out of Julian date 4
Date minus 3 months 3
matching month and year column. 3
Count According to Date 1

Back
Top