days between dates

  • Thread starter Thread starter Gordon Abbot
  • Start date Start date
G

Gordon Abbot

I have used the excel help but have hit a brick wall.

I would like to get the fraction (4/30/2006- TODAY())/365 (or 4/30/2006
- 5/1/2005).

When I tried the DAYS360 or DATEVALUE I get either very large or small
numbers but no whole numbers for days. I have tried just TODAY()- a date
and that also gives a large number. I realize this is probably a simple
solution, but I am in the dark.

Thanks.

GA
 
Gordon,

Date-time value for 4/30/06 can be gotten with DATEVALUE("4/30/06"). So you
could use

=(DATEVALUE("4/30/2006")- TODAY())/365

This returns 0-.816438 for today of 7/6/2005, or 81.6% of a year. If I use
today's date in place of the 4/30/2006, I get exactly 1, as would be
expected.
 
Hi Gordon,

Maybe you should try to use the correct notation for dates, such as:

= (DATE(2006,4,30))-TODAY())/365

or

= (VALUE("4/30/2006")-TODAY())/365

or

= (DATEVALUE("4/30/2006")-TODAY())/365

etc.

Regards,
KL
 
Back
Top