=DATE(YEAR(P4),MONTH(P4)+1,1)

dlotz · Jan 22, 2009

I cant seem to get his one right.
How can revise this formula so the cell is
blank until data is typed in P4 cell
Please advise

Gary''s Student · Jan 22, 2009

=IF(P4="","",DATE(YEAR(P4),MONTH(P4)+1,1))

Dave Peterson · Jan 22, 2009

You may even want:

=if(isnumber(p4),DATE(YEAR(P4),MONTH(P4)+1,1),"")