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

[dlotz]

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]

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

 

[Pecoflyer]

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

Hi

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

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Dave Peterson]

You may even want:

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