360 Days

R

Raf

Ok if anyboby can help me with this one?
Im trying to set a sheet up that will calculate at a daily rat
starting at one date and ending at another then times that by a rate
but get this ? it only goes to 360 days yes im 5 days short
can anybody please help.
Thanks Sea
 
M

Myrna Larson

Sounds like you're using DAYS360 to calculate the difference in the dates.
That's a specialized function used in the financial world to simplify some
calculations: all months are assumed to have 30 days, so there are 360 days in
a year. To get the number of days, with dates in A1 and B1 =B1-A1. Add 1 to
make it inclusive on both ends.
 
Top