Great Video! Slight different result I'm looking for however.. Is there a way of altering this formula so rather than having it be a running total, you're adding a fixed value each month? That way you don't have to add the table, there is just a start date and Today(), then it adds a fixed value the first of each month. Seems easy but I can't find the answer anywhere!
Thank you. Assuming the date "from" is in A1, the date "to" is in A2, and the fixed monthly amount is 100, the following formula will add 100 for each 1st day of the month within the range: =100*((YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)+1) Adjust the amount and references to suite your workbook. Hope this helps!
simple but sensational.
Thank you :)
Thank you sir
Great info. Thanks Jeff
You're welcome!
Mr. Jeff, I just typed over the formula to add date values, The Dutch version of Excel uses ";" instead of "," to separate the arguments
Great Video! Slight different result I'm looking for however.. Is there a way of altering this formula so rather than having it be a running total, you're adding a fixed value each month? That way you don't have to add the table, there is just a start date and Today(), then it adds a fixed value the first of each month.
Seems easy but I can't find the answer anywhere!
Thank you. Assuming the date "from" is in A1, the date "to" is in A2, and the fixed monthly amount is 100, the following formula will add 100 for each 1st day of the month within the range:
=100*((YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)+1)
Adjust the amount and references to suite your workbook.
Hope this helps!