markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
BC Plan A & B + Resources.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |||
3 | Monthly Cost | Start | End | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | ||
4 | 11,083 | May-23 | Jul-23 | 11,083 | 11,083 | 11,083 | |||||||||||||||
Plan B - Resource Calculations |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G4 | G4 | =F4/12 |
Hello,
I have the above table. The start date in column H is the first date when a payment needs to be entered the end date in column I is the last date when the payment should be entered. I was hoping to get a formula that I can drag across that will apply the monthly cost in column G to all the dates between the start date and end date inclusive. So if May 23 is the first date July 23 is the end date it will add the amount on column G to May 23, June, 23, July 23 on that row - does that make sense? Thanks