+ 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 (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    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