Forum Discussion
Autofill data across columns based on dates
Having some trouble autofilling a spreadsheet to include phased revenue across months. Column Headers Horizontally are: Project Name Project Start Date Project End Date Project Duration (Months) Mo...
eeJFTS hello there. I'm assuming you want the same 'Monthly Value' to appear in the month columns dependent on their start and end dates. If so, you could use something like the below formula. It was used in cell G2 of your sample spreadsheet. You can copy it right and down.
=IF(AND(G$1>=EOMONTH($C2,-1)+1,G$1<=EOMONTH($D2,0)),$F2,0)
HTH