thnx for effort anthony, but if i do copy paste (so no spelling errors) it
unfortunately does not work... hwat is the "d"? and should they range not
have a colon instead of comma? and what does datedif actually do? they other
given solution did do the job, so i have a solution, but this intrigues me
now..... maybe u can clarify it a litlle bit more? im from the netherlands so
not a native english speaker (maybe this plays a role in misinterpreting what
you say...?). thnx again and looking 4ward to hear more. jozef

"Anthony" wrote:
This has worked for me in the past and can be used for number of days,
months, etc. between two dates:
=datedif(A1, B1, "d") where cells A1 and B1 contain the two dates.