Date Validation

[sahaider]

44155 00/01/1900 0 44215 18/08/2019 1 44240 00/01/1900 0 44246 00/01/1900 0 44289 00/01/1900 0 44336 15/07/2019 1 44375 17/06/2019 1 44387 18/06/2019 1 44434 12/06/2019 1 44443 00/01/1900 0 44506 00/01/1900 0 44513 00/01/1900 0 <colgroup><col width="64" style="width: 48pt;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <tbody> </tbody>

<tbody>
</tbody>

hello,
After doing a vlookup on dates some entries are coming back as 00/01/1900 which is i think is due to blank cells where date entry is not present. Can i check on these returned entries so if date returned is 00/01/1900 it will show 0 else 1.

End result of what i am after is shown above.
Thanks

 

[tyija1995]

Hey,

Nest your VLOOKUP formula in an IF statement,

=IF(*VLOOKUP FORMULA*=0,0,1)

Note that 00/01/1900 is the same as 0