I am using the
DAYS360 formula to count how many days since last activity from a predefined date
The R Column reports on last activity date, whilst the the X1 cell contains the current date.
All is good except for when the there is no date in Column R. The formula then spits out an amount of days of
40753 (this increases day by day).
How to i add to my above formula so that if the value is
>= 40753 the value returned is 0 or NO ACTIVITY?