Forum Discussion
packie
May 08, 2024Brass Contributor
If cell is true return nothing
Hi, Col B = contains dates in the range Col L = contains dates in some cells in the range At the moment I am using the following formula: =TODAY()-B12 Now I want to put a condition into...
- May 08, 2024
packie Perhaps this:
=IF(ISBLANK(L12),TODAY()-B12,"")
Riny_van_Eekelen
May 08, 2024Platinum Contributor
packie Perhaps this:
=IF(ISBLANK(L12),TODAY()-B12,"")