I'm averaging dates in Excel and getting a number I don't understand. Why?

Question

Grade: Education Subject: Support

Asked by: USER9632

74 Viewed 74 Answers

Responsive Ad After Question

Answer (74)

USER2233

Best Answer

(290)

Excel stores dates as sequential serial numbers. When you average dates, you're averaging these serial numbers. The result is also a serial number, which Excel displays as a date. To understand the result, change the cell format to 'General' or 'Number' to see the underlying serial number.

Answered on 30 Agustus 2025

If I'm the owner of a file and still getting a permission error, what should I try?

3 September 2025 83 views 83 comments

Which word best completes this sentence?

Después de estacionar mi auto y volver de las compras, pagaré el ___________.

A. boleto
B. parquímetro
C. tarjeta
D. vehículo

3 September 2025 160 views 216 comments

What kinds of problems did progressives attempt to solve?

3 September 2025 58 views 58 comments

What does the term aryan mean and how did the nazis misuse the term

3 September 2025 68 views 68 comments

How many protons electrons and neutrons does an Adam with an atomic number 50 and mass number 125 contain

3 September 2025 105 views 105 comments

Teenage drivers are more likely to be involved in a crash when

3 September 2025 63 views 63 comments

Dintre toate numerele mai mari decat 23 si mai mici decât 54, Radu alege numarul cu suma cifrelor cea mai mica si numarul cu suma cifrelor cea mai mare. Care este suma numerelor gasite de Radu?

26 Agustus 2025 160 views 194 comments

How does the absence of a global error handler affect API responses?

28 Agustus 2025 68 views 68 comments

Write a letter to your friend in another school telling him or her about your future career and how it will be beneficial to your country

27 Agustus 2025 138 views 138 comments

Berat suatu benda 34,3 N. Jika percepatan gravitasi bumi 9,8 N /kg, massa benda tersebut adalah

3 September 2025 96 views 96 comments

1. She did not to have all her belongings.....
A: stolen. B:steal. C:be stolen

2.He... downstairs to get something to eat, but hr had dropped thr biscuit tin on the floor.
A: was going. B:went. C:had gone

3.They both laughed and... went back to bed.
A: then. B:after. C:next

Repedeeeee

26 Agustus 2025 160 views 361 comments

I'm averaging dates in Excel and getting a number I don't understand. Why?

Question

Answer (74)

Related Articles

If I'm the owner of a file and still getting a permission error, what should I try?

What are the common permission levels in macOS and what do they signify?

How can I check the permissions of a file on my MacBook?

Why might a word processing document fail to 'save' with a permission error?

What does a 'file permission error' typically mean in the context of macOS?

Which word best completes this sentence? Después de estacionar mi auto y volver de las compras, pagaré el ___________. A. boleto B. parquímetro C. tarjeta D. vehículo

What kinds of problems did progressives attempt to solve?

What does the term aryan mean and how did the nazis misuse the term

How many protons electrons and neutrons does an Adam with an atomic number 50 and mass number 125 contain

Teenage drivers are more likely to be involved in a crash when​

Dintre toate numerele mai mari decat 23 si mai mici decât 54, Radu alege numarul cu suma cifrelor cea mai mica si numarul cu suma cifrelor cea mai mare. Care este suma numerelor gasite de Radu?​

How does the absence of a global error handler affect API responses?

Write a letter to your friend in another school telling him or her about your future career and how it will be beneficial to your country

Berat suatu benda 34,3 N. Jika percepatan gravitasi bumi 9,8 N /kg, massa benda tersebut adalah

1. She did not to have all her belongings..... A: stolen. B:steal. C:be stolen 2.He... downstairs to get something to eat, but hr had dropped thr biscuit tin on the floor. A: was going. B:went. C:had gone 3.They both laughed and... went back to bed. A: then. B:after. C:next Repedeeeee

Which word best completes this sentence?

Después de estacionar mi auto y volver de las compras, pagaré el ___________.

A. boleto
B. parquímetro
C. tarjeta
D. vehículo

Teenage drivers are more likely to be involved in a crash when

Dintre toate numerele mai mari decat 23 si mai mici decât 54, Radu alege numarul cu suma cifrelor cea mai mica si numarul cu suma cifrelor cea mai mare. Care este suma numerelor gasite de Radu?

1. She did not to have all her belongings.....
A: stolen. B:steal. C:be stolen

2.He... downstairs to get something to eat, but hr had dropped thr biscuit tin on the floor.
A: was going. B:went. C:had gone

3.They both laughed and... went back to bed.
A: then. B:after. C:next

Repedeeeee