Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 20, 2012 at 10:27 AM
Hi Femina,

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

Best regards,
Trowa

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses
Unable to change date format in Excel
rznbyz -
Tobby -

Hello,
I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I double click in each individual cell and then move out of that cell the format changes and the dates appear correct. I have 24854 dates I need to change, I can't take time to double click in each cell. Any suggestions? Thanks

39 responses