Excel help

Closed
femina
Posts
5
Registration date
Tuesday July 31, 2012
Status
Member
Last seen
August 1, 2012
- Aug 1, 2012 at 07:43 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Aug 20, 2012 at 10:27 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Aug 20, 2012 at 10:27 AM
Hi Femina,

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

Best regards,
Trowa
0