+ Reply to Thread
Results 1 to 4 of 4

Spreading income over years based on start and end date - a variation

  1. 10-18-2022, 11:02 AM #1
    R3Dxcel
    R3Dxcel is offline
    Registered User
    Join Date
    10-18-2022
    Location
    The Netherlands, Europe
    MS-Off Ver
    Excel for Mac v16 with M365 Subscription MacOS 12.6
    Posts
    3

    Question Spreading income over years based on start and end date - a variation

    Dear all,

    Sorry to barge into this forum just like that. I'm trying to find a solution for something for quite some time now.

    It seems a similar question or variation to the thread called: "Formula to spread cost across years based on the start date and no. months in the peri"

    What is want however is to devide the income of several projects over years, with start and end date that can run accross years and relative to the amount of months in each year.
    The orange columns (Project size, start and end date) are populated manually, the rest should be automatic.

    In the attachment it is made clear (hopefully) what I'm looking for. I hope to solve this puzzle that is buggin me for quite some time.

    Attachment 801163


    Any help is appreciated!

    By the way, not sure if it bares any relevance. I use Excel for Mac, running version 16.66 on a MS365 Subscription.
    So not sure if I can use all formulas (e.g. Datedif isn't known to my excel, but Xlookup is...so not sure).
    Reply With QuoteRegister To Reply
  2. 10-18-2022, 11:05 AM #2
    AliGW
    AliGW is offline
    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: Spreading income over years based on start and end date - a variation

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    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 With QuoteRegister To Reply
  3. 10-18-2022, 01:53 PM #3
    R3Dxcel
    R3Dxcel is offline
    Registered User
    Join Date
    10-18-2022
    Location
    The Netherlands, Europe
    MS-Off Ver
    Excel for Mac v16 with M365 Subscription MacOS 12.6
    Posts
    3

    Re: Spreading income over years based on start and end date - a variation

    Hi there!
    Of course, makes sense. It is a reflex to be honest, there are so many (online) places where they want to know stuff..
    I adjusted it! Thanks
    Reply With QuoteRegister To Reply
  4. 10-20-2022, 10:41 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,531

    Re: Spreading income over years based on start and end date - a variation

    For me, selecting the attachment in post #1 results in the following: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
    There is information in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page that may be helpful in attaching an Excel file to your next post.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Distributing Cost over multiple years based on start and end date
    By marks9172 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2022, 01:23 PM
  2. [SOLVED] Spreading contract amount across months by start/end date
    By awexy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2021, 12:36 PM
  3. Spreading Amount based on Date Range
    By neildcd in forum Excel General
    Replies: 1
    Last Post: 06-26-2018, 03:25 AM
  4. How many years from start date formula
    By Rumpus24 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-26-2018, 06:58 AM
  5. Split Start End date into multiple years
    By tos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2016, 06:42 AM
  6. Spreading Hours based on Project Phases and Start/End Date
    By ChelseaT20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2012, 04:38 PM
  7. [SOLVED] How to determine how many fiscal years are present from start date to end date.
    By terrivega3500 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-07-2012, 01:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1