Date Validation

[sahaider]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 221"]
<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>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]44155[/TD]
[TD="width: 112, bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="width: 119, bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44215[/TD]
[TD="bgcolor: transparent, align: right"]18/08/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44240[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44246[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44289[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44336[/TD]
[TD="bgcolor: transparent, align: right"]15/07/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44375[/TD]
[TD="bgcolor: transparent, align: right"]17/06/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44387[/TD]
[TD="bgcolor: transparent, align: right"]18/06/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44434[/TD]
[TD="bgcolor: transparent, align: right"]12/06/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44443[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44506[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]44513[/TD]
[TD="bgcolor: transparent, align: right"]00/01/1900[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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