Could someone explain this formula?

  • Thread starter Thread starter Caezar
  • Start date Start date
C

Caezar

Bob Philips posted a very elegant solution to a Date formula problem.

=MIN(DATE(YEAR(A1),MONTH(A1)+{2,1},DAY(A1)*{0,1}))

This is the first time I encounter curly braces "inside" (as opposed
to "wrapped around") a formula. I suppose this is still an array
formula.

Could anyone point to some documentation on the net that explains this
feature of Excel? I tried to Google:
Excel + curly + braces
Excel array formulas

But I could not find any relevant explanation.

Thanks!

Caezar
 
BTW it is NOT an array formula, even though it uses an array constant.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top