Hello,
Pretty basic one, but I can't seem to figure it out. I'm pretty ignorant to sheets formulas.
I need to split the deal revenue across each month based on the start date and end date of a campaign. As an example, A2 needs to be split for the last 3 days of May, the first 8 days of June. The revenue for the 3 days in May should appear in the May column and the 8 days of revenue for June should appear in the June column. If no revenue in a month, the cell should return '0'.
Example:
https://docs.google.com/<wbr>spreadsheets/d/<wbr>1jO9ZpMbYqnOmrxt5NL8KhP5NevvhH<wbr>KUekDwdXmiF6wc/edit#gid=0
Any help would be greatly appreciated. Everything I've researched seems to be complicated and not what I need to return.
Pretty basic one, but I can't seem to figure it out. I'm pretty ignorant to sheets formulas.
I need to split the deal revenue across each month based on the start date and end date of a campaign. As an example, A2 needs to be split for the last 3 days of May, the first 8 days of June. The revenue for the 3 days in May should appear in the May column and the 8 days of revenue for June should appear in the June column. If no revenue in a month, the cell should return '0'.
Example:
https://docs.google.com/<wbr>spreadsheets/d/<wbr>1jO9ZpMbYqnOmrxt5NL8KhP5NevvhH<wbr>KUekDwdXmiF6wc/edit#gid=0
Any help would be greatly appreciated. Everything I've researched seems to be complicated and not what I need to return.
