I am using the `DAYS360`

formula to count how many days since last activity from a predefined date

```
=DAYS360($R15,$X$1)
```

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**?

`=DAYS360(DATE(2013,3,30),DATE(2013,4,1))`

gives a result of 1 - but those dates are 2 days apart - if you want an accurate number of days between two dates just subtract the earlier from the later, e.g. in your case`=IF($R15="","",$X$1-$R15)`

– barry houdini Mar 13 '13 at 11:59