Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 276
- Office Version
- 365
- Platform
- Windows
Office 365
Average upto the current month
I want to find average upto the month
for this calendar year.
Cell J15 contains number: 75000. Column A5:A371
contain date in dd-mm-yy format.
Current month is Nov, i.e 11 for this calendar
year. =J15/11. I want this auto average calculation
for all the months based on dates in Column A5:A371.
Kindly advise me formula.
Average upto the current month
I want to find average upto the month
for this calendar year.
Cell J15 contains number: 75000. Column A5:A371
contain date in dd-mm-yy format.
Current month is Nov, i.e 11 for this calendar
year. =J15/11. I want this auto average calculation
for all the months based on dates in Column A5:A371.
Kindly advise me formula.