Thread: Months
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jose Jose is offline
external usenet poster
 
Posts: 35
Default Months

Sorry, I made some typos.
DATE 1: 01/08/2008
DATE2: 31/12/2009

Total months 17
--
Many thanks for your help,
Jose


"Joel" wrote:

You need to include the year

=12*(Year(D3)-Year(C3))+Month(D3)-Month(C3)

"Jose" wrote:

I have the following problem with dates:
C3 D3
01/08/2008 31/11/2009


When I ask D3-C3 I get 5 instead of 18. How am I doing wrong?
--
Many thanks for your help,
Jose