Hi everyone,
I was wondering if you could help.
Is there a formula I can put in cells D3-G4 that looks at the start and end dates in columns A & B, counts the number of days that used in the month (E2-G2) and then multiplies the number of days by the cost in column C?
If it helps, the value in D2 is currently 31/01/2020 but Formatted to "Mmm"
Thanks a lot
I was wondering if you could help.
Is there a formula I can put in cells D3-G4 that looks at the start and end dates in columns A & B, counts the number of days that used in the month (E2-G2) and then multiplies the number of days by the cost in column C?
If it helps, the value in D2 is currently 31/01/2020 but Formatted to "Mmm"
Thanks a lot
A | B | C | D | E | F | G | |
1 | Spend per month | Spend per month | Spend per month | Spend per month | |||
2 | Start | End | Cost per Day | Jan | Feb | Mar | Apr |
3 | 20/01/2020 | 04/02/2020 | 15 | 165 | 60 | ||
4 | 27/02/2020 | 07/04/2020 | 20 | 40 | 620 | 140 |