View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default 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!