Hello,
i need help with the below I have many projects with cost that i need to divide: here is one line.
start Date 02/10/2022
end date 05/06/2022
cost : $35,000
Looking to project the average cost between those 2 dates per month.
solution: 86 days between start and end date
19 days in February x $406.97 ($35000/86)= $7,732
Jan:$0 cost
Feb: $7,732 cost
March : 31 days * 406.97
April : 30 days x $406.97
May: 6 days x $406.97
this formula in excel normally gives me that, but smartsheets doesnt work.
SUMPRODUCT(--(MONTH(ROW(INDIRECT($A2 & ":" & IF($B2="",TODAY(),B2))))=MONTH(C$1)))