+ Reply to Thread
Results 1 to 2 of 2

display duration in decimal months spread over calendar cells

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    4

    Question display duration in decimal months spread over calendar cells

    Hi all, looking for some help in coming up with a formula that will display a duration in decimal month spread over a calendar format.

    So for example if the start date is 01 Jan 2020 and the end date is 15 Apr 2020, I want the result to show :

    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    1 1 1 0.5 0 0 0 0 0 0 0 0


    I've dabbled with MONTH and IF and come up with either a formula that returns the duration in one number (3.5) or another that just marks each month with a 1 if the end date is greater or equal to 1 for Jan, 2 for Feb etc. The latter is closer to what I need but only works if there are full months, any idea how I can get results as shown in the example above?

    Thanks!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,204

    Re: display duration in decimal months spread over calendar cells

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] networkdays and calendar duration
    By bobelmore in forum Excel General
    Replies: 5
    Last Post: 08-17-2016, 08:49 PM
  2. Calendar Duration Formula
    By chris8877 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2014, 04:22 PM
  3. [SOLVED] Display cells 12 months prior and 12 months post from a given date
    By hog77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2012, 06:25 AM
  4. Convert Duration to Numbers of Months
    By VICTOR5 in forum Excel General
    Replies: 7
    Last Post: 06-13-2011, 07:31 AM
  5. Using duration in a calculation H:mm:ss to decimal
    By grigsy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-27-2011, 03:33 AM
  6. Set an array on based on duration of months
    By Robog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2006, 06:35 PM

Tags for this Thread

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