21 February 2014

Validate date in excel

I now realize that Excel is a powerful tool..  hehehe

to validate a date in cell, put a formula next to it like this
=isnumber(datevalue([cell]))
it's simple right?

:)

No comments:

Post a Comment

Twiit.. Twiit... Gulp