I am able to calculate aging in my column L based off a date entered in column K whether or not a date has been entered in column M.
But what I would like is for my column L to ignore the aging formula if a beginning date has not been entered in column K.
Currently excel returns a value of 43185 if column K is blank. My current formula in row 3 column L is as follows:
=IF(M3<>"",M3-K3,TODAY()-K3)
Any help would be greatly appreciated!
But what I would like is for my column L to ignore the aging formula if a beginning date has not been entered in column K.
Currently excel returns a value of 43185 if column K is blank. My current formula in row 3 column L is as follows:
=IF(M3<>"",M3-K3,TODAY()-K3)
Any help would be greatly appreciated!
Last edited: