Forum Discussion

AlinMihalcea1's avatar
AlinMihalcea1
Qrew Assistant Captain
8 years ago

Spread income or cost over months

I'm looking at a way to allocate project revenue over multiple months. Lets say I have a project that starts on 6/25/17 and ends on 7/15/17 that brings a revenue of 10K. I need to split this revenue between June  and July based on the number of days the project spans over each month.

Anyone ideas?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Split it into days, and then summarize those days into the respective months.  (thats the short answer)

    The long answer would take some time to describe, and might not meet all your needs.

    Does that help point you in the right direction?  or Should we explore more?