Excel help [Closed]

Report
Posts
5
Registration date
Tuesday July 31, 2012
Status
Member
Last seen
August 1, 2012
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I have a sales performance sheet where I always update the sale. There is a column for the overall average sales where I need to update it manually as the days go...,
for example if today's date is 22/07/2012, the average column should be updated the average sales automatically. See below:

If the cell "n32" is the sum of the sale of till 22/07/2012, assume 250; then the cell for average "n33" should be = 250/22. And next day when I update it for 23/07/2012, then the average column automatically updated as ( assume the sale is 265, it should be divided by 23!!!

Please help to solve the problem.

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Femina,

Use this formula in N33:
=N32/DAY(NOW())

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!