I have a formula in a cell which brings back a certain date.
However the referenced cells maybe blank as such my initial formula will bring back 00/01/1900. I did struggle trying to find a way for excel not show this figure and found the following works.
( note the 2 ;; )
this will leave the cells blank and me happy.
in a subsequent cell I am using this cell with the blank as a reference and using the following formula:
The issue I not face is that this formula above does not see that R30 is blank,
whilst it looks blank it really show 00/01/1900.
the result of the formula above is -40694 which looks like a date in number format.
I want to ensure that if either R30 or L30 are blank then a NA is returned. otherwise to perform the r30 - l30.