Forum Discussion
Updating cell value automatically monthly or weekly etc.
Hi I am wondering if there is a way to update cell value automatically in certain period of time, for example monthly. I need this because I want to keep track of Customer Lifetime Revenue. W...
If your start date is in B2, you may use this formula in C2 to calculate lifetime revenue:
=DATEDIF(B2,TODAY(),”m”)*10+100
=DATEDIF(B2,TODAY(),”m”)*10+100
Sorry I must have misunderstood. I thought the requester wanted that to happen without even opening Excel and that populated.