2 functions in 1

  • Thread starter Thread starter Chey
  • Start date Start date
C

Chey

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
 
Like
=IF(V4<31,"",DATE(YEAR(V4),MONTH(V4)-(V4>1),DAY(V4)))
or the little more mysterious
=IF(V4<31,"",DATE(YEAR(V4),MONTH(V4)-(V4>31),DAY(V4)))

HTH. Best wishes Harald
 
Back
Top