days between dates calculation

  • Thread starter Thread starter redpenner
  • Start date Start date
R

redpenner

I am looking for a function I can use in Excel 2K to calculate the
number of days between two dates. I want to base this on a 365-day
year (not 360, so DAYS360 won't help).

This is on an office computer, and I don't know whether the Add-Ins
are available, but if they are, can I use YEARFRAC as follows to
accomplish this? Would it be accurate?

=(YEARFRAC(A1,A2))*365

Or, is there another way? I want to be able to enter "start_date"
and "end_date" in dd-mm-yy format.


Any advice would be appreciated!!

redpenner
 
Niek Otten said:
=A1-A2
Click to expand...


Oh my gosh, am I brain-dead or what?!?! (don't answer that)
This makes perfect sense, now that I think about it.

Thank you so much!!
 
Back
Top