use date to return value of 1Closed

Question

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

RayH · Answer

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.

Use date to return value of 1

1 response

Similar discussions

Subscribe To Our Newsletter!