Trying to spread projected sales revenue over a number of months based on projected order date.
Inputs - projected order month, total revenue, number of months the job is expected to last.
Have tried -
Created a 12 month calendar - compare expected order month with calendar month - if yes, then spread order based on number of months
=IF($H$7=$L$6,IF(COLUMNS($L7:L7)>$F7,"",$G7/$F7),"")
But it only works for the first date occurrence. (i.e. this formula test for month of October, next cell tests for November. When expected order month is October will not spread data in cell with November test.
Sample attached.
Thanks,
Bookmarks