ExcelBanter - 2 functions in 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 2 functions in 1 (https://www.excelbanter.com/excel-discussion-misc-queries/227786-2-functions-1-a.html)

Chey

2 functions in 1

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

Gary''s Student

2 functions in 1

=IF(V4="","",DATE(YEAR(V4),MONTH(V4)-1,DAY(V4)))
--
Gary''s Student - gsnu200846

Harald Staff[_2_]

2 functions in 1

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

All times are GMT +1. The time now is 12:38 PM.