Use date to return value of 1 [Closed]

Report
Posts
1
Registration date
Friday February 26, 2016
Status
Member
Last seen
February 26, 2016
-
 RayH -
Hi, can anyone tell me how to use the entry of a date field to return a value of 1 in Excel? I need to tabulate items where a date is the entered record, as used in progress. Specifically, I enter a date and I need a return value of 1 in an adjacent cell.

Thank you

1 reply

There is no standard Excel function that checks for a data value without resorting to custom macros.
However, we can check for empty cells:
=NOT(ISBLANK(A1))*1

If Data Validation is placed on the cell (or cell range) you are checking, in this case A1, then the cell will only be allowed to contain Dates or nothing.