Bob Phillips Wrote:
Another way

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

which is an array formula, it should be committed with
Ctrl-Shift-Enter, not
just Enter.



Bob, my understanding is that this formula only requires enter,
certainly works OK for me that way


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=510940