Try one of these:

=IF(COUNT(K4),(TODAY()-K4)/365*12,"N/A")

=IF(COUNT(K4),(TODAY()-K4)/365*12,"")

--
Biff
Microsoft Excel MVP


"CrewDog130" wrote in message
...

I would like a to make the cell with the following formula display "N/A"
or remain blank when a date is not entered in K4. Does anyone have any
suggestions?

=((TODAY()-K4)/365)*12


--
CrewDog130
------------------------------------------------------------------------
CrewDog130's Profile:
http://www.thecodecage.com/forumz/member.php?userid=612
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=122178