Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Formula calculate months starting from november

    Hi All,


    I have a date in cell I4 like "dd/mm/yyy" it always change according to new report . i need formula that calculates the number of months starting from november to october. suppose i have date is 01/04/2012 then formula shows "6" month in other cell if date like 01/09/2012 then formula calculate number of months starting from november which will be 11 months ?


    Thanks
    farrukh

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    =month(i4)-10+(month(i4)
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Hi rory

    i am gettin -2 figure??
    I have date 01/04/2012

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Sorry - the forum truncated my post and I didn't notice. The formula should be:=month(i4)-10+(month(i4) < 11)*12
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Great it works !

    Thank you

    farrukh

Posting Permissions

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