I am using the DATEIF function to stop counting the numbers of days open when a closed date is input in another cell.
I also need the formula to work when the cell with the creation date is blank.
Here is my Formula
AA=DATEDIF($Z4,IF(H4>0,H4,TODAY()),"D")
If Cell $Z4 is empty i.e. there is no creation date the cell AA should be blank/empty
Should I use the OR Function? If so how?
I also need the formula to work when the cell with the creation date is blank.
Here is my Formula
AA=DATEDIF($Z4,IF(H4>0,H4,TODAY()),"D")
If Cell $Z4 is empty i.e. there is no creation date the cell AA should be blank/empty
Should I use the OR Function? If so how?