Like
=IF(V4<31,"",DATE(YEAR(V4),MONTH(V4)-(V41),DAY(V4)))
or the little more mysterious
=IF(V4<31,"",DATE(YEAR(V4),MONTH(V4)-(V431),DAY(V4)))

HTH. Best wishes Harald

"Chey" wrote in message
...
Right now I have
=DATE(YEAR(V4),MONTH(V4)-1,DAY(V4))

Works great however if I don't have a date in V4 then it comes back NUM.
How
can I get rid of that. Can I do an if statement? or is just a cell format?

Thanks
Cheyenne