answersLogoWhite

0


Best Answer

In Excel every cell contains what is seen (value) and what is not seen (formula) and in most cases these are the same thing. When you enter a date in the cell Excel recognizes this and instantly converts the date into a single number whose value represents the number of days from January 1, 1900. You can format the cell to still appear as a date but the formula contains this number which makes it easy to compare or sort against other cells also containing dates.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

True statement, but not a question. If there is something you would like to know. Ask again, using words that indicate what you would like to know.

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

It assigns a serial value.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When you enter a date Excel assigns a what value to the date which makes it possible to treat dates like other numbers for the purpose of calculating the number days between two dates?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Who assigns aircraft registration numbers?

No one assigns the N-number. You get to request one. You can request one on the FAA website.


What number is halfway between 12 and 82?

Calculating the average of the two numbers gives you the answer. (Add the two numbers, then divide the result by 2.)


What is the number halfway between 710000 and 800000?

You can calculate that by calculating the average between the two numbers.


What does subtracting mixed numbers mean?

In means calculating the difference between one mixed number and another mixed number.


Who assigns numbers to airplanes?

In the United States, the Federal Aviation Administration (FAA)


What are the numbers between 40 and 60?

There are infinitely many numbers between 40 and 60 so it is not possible to list them.


What is the formula for calculating average?

[sum of numbers on list] ÷ [amount of numbers in list]


What is the two whole numbers which lie between these values 71?

It is not possible to have any numbers lying between ONE number.


What is calculating the sum of two or more numbers?

addition


Which number is equal to 80 600 1?

It is not possible to answer the question since there are no operators between the numbers. 80 + 600 is very different from 80 * 600!It is not possible to answer the question since there are no operators between the numbers. 80 + 600 is very different from 80 * 600!It is not possible to answer the question since there are no operators between the numbers. 80 + 600 is very different from 80 * 600!It is not possible to answer the question since there are no operators between the numbers. 80 + 600 is very different from 80 * 600!


What is the formula for calculating phone numbers?

Phone companies assign phone numbers arbitrarily; there is no formula.


What are the importance of integers?

Integers help learners to count numbers and also to help in calculating numbers.