Results 1 to 2 of 2

Thread: Distribute the Number 1 between two Dates

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte JaberwokieinAlice's Avatar
    Join Date
    Aug 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Distribute the Number 1 between two Dates

    I am looking for the formula that does the following spread / distribution between a start date and an end date: if the start date is mid month it calculates 14/31, etc, then between the start and end months inserts the value 1 and for the final month identifies the value of the end date 10/31. e.g. refer to the table below.The values not equal to 1 are to be rounded up. The months reflected in the columns are the end of the month e.g. 31 Oct or 30 Nov, etc


    Net Programme Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20
    Start Date End Date 2019 2020
    Q 4 Q 1 Q 2 Q 3 Q 4
    Overall Project
    Contract Award -> Practical Completion 14/10/2019 10/12/2020 0.5 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,253
    Articles
    0
    Excel Version
    Office 365 Subscription
    CROSS POST

    This question has been posted in at least one other forum.
    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
    Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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