ExcelBanter - Extract Date

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Extract Date (https://www.excelbanter.com/excel-worksheet-functions/72604-extract-date.html)

christmaslog

Extract Date

I use vlookup to extract cell which contain date. How do I format it so that
it will not display any value if the source cell in empty?

Niek Otten

Extract Date

FormatCellsNumberCustom

In the type box, enter two semicolons (;) to the end of the formatting
string

--
Kind regards,

Niek Otten

"christmaslog" wrote in message
...
I use vlookup to extract cell which contain date. How do I format it so
that
it will not display any value if the source cell in empty?

All times are GMT +1. The time now is 03:26 PM.