+ Reply to Thread
Results 1 to 2 of 2

Wrong months in a year

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    1

    Wrong months in a year

    hi guys,

    i'm trying to get excel to work out the number of months within to dates:-

    06/04/2010 to 05/04/2011
    or
    06/04/2011 to 05/04/2012
    or
    06/04/2012 to 05/04/2013

    These are tax year dates and since the taxman regards it as a full year, i can only use these dates. The problem i have is that excel is classing these dates as 11 months, rather than 12 months just because of one day less...how can i correct this?

    FYI, I'm currently using this formula:-

    =DATEDIF(B3,C3,"m")


    Thanks for your help
    Last edited by excelpert; 10-18-2012 at 11:13 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,714

    Re: Wrong months in a year

    The easiest is probably to change the C3 to C3+1:

    =DATEDIF(B3,C3+1,"m")

    but I'm not sure how that might affect other things that you use the formula for.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1