Use date to return value of 1
Closed
frozentundra
Posts
1
Registration date
Friday 26 February 2016
Status
Member
Last seen
26 February 2016
-
26 Feb 2016 à 16:32
RayH - 27 Feb 2016 à 10:13
RayH - 27 Feb 2016 à 10:13
Related:
- Return value 1
- Tentacle locker 1 - Download - Adult games
- Igi 1 - Download - Shooters
- Fnia 1 apk - Download - Adult games
- My cute roommate 1 - Download - Adult games
- Thunderbird return receipt - Guide
1 response
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.
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.
