Billing Projection

A.wright

All,

Inquiring about breakout of 'Project Contract' to populate evenly across months based on 'Last Day of Start Month' & 'Last Billing Period.' Ex: Project Name 24006 would show $113,915 in June, July, and August to equal $341,745. Perhaps an added column in sheet is needed, that already has the even split sum.

Attached for reference.

Jgorsich

Your proposed idea of an extra column is probably the easiest.

=[project contract]@row/(month([last billing period]@row)-month([last day of start month]@row))

would work for any thing inside of a single calendar year. As you WILL have things that span a single calendar year, you might need to modify it to be:

=[project contract]@row /(if(month([last billing period]@row )<month([last day of start month]@row),month([last billing period]@row )+12,month([last billing period]@row ))-month([last day of start month]@row )).

You might also need to protect against a scenario where a project is only 1 month, but you can decide if you need that.