how to add a value based on a date change in Excel?
Do you want to add the same amount on the first of every month?
If, for instance you want to add the amount in cell B1 every first of the
month from October 2006
=DATEDIF(DATE(2006,10,1),TODAY(),"m")*B1+B1
"Eric" wrote:
I am trying to add a value to another on the first of the month. It is a
repeating condition based on the first of the month. Thanks for your help!
|