Use date to return value of 1

frozentundra Posts 1 Registration date Friday February 26, 2016 Status Member Last seen February 26, 2016 - Feb 26, 2016 at 04:32 PM
 RayH - Feb 27, 2016 at 10:13 AM
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:

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.