I used DAYS360 to calculate the number of days between today (Jul 21) and 2
NOV 2005 as follows: =DAYS360(TODAY(),"11/02/2005") and got 101. However,
when I actually count the days on the calendar (Jul=10, Aug=31, Sep=30,
Oct=31, Nov=1) I get 103. Can you tell me why there is a discrepancy? The
only thing I could come up with is there are two holidays in that time frame
- does function DAYS360 excude holidays? Thanks.