answersLogoWhite

0

It stores a date as a number which is the number of days starting on the 1st of January 1900 to the date being stored.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

When you enter a date excel assigns a what value to the date?

numerical


When you enter a date Excel assigns a?

a serial value to the date


When you enter a date excel assigns a value?

This is a true statement, but is not a question. Ask again using words that make it clear what you want to know.


What happens when Excel assigns a formula value to the date?

This question is not clear. You can use dates in a formula, but you can not assign a formula value to a date. If you are trying to use dates in formulas, use them like you would any other number. If A1 contains a date, you can show the date six days earlier by using the formula =A1-6.


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?

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.


A function is a relatship that assigns one?

It assigns exactly one output value for each input value.


What is the relationship of a domain and a function?

A function is a rule that assigns a single value to each element in a domain.A function is a rule that assigns a single value to each element in a domain.A function is a rule that assigns a single value to each element in a domain.A function is a rule that assigns a single value to each element in a domain.


What style is the format style that excel assigns to all cells in a work book?

The default format style that Excel assigns to all cells in a workbook is the General format. This format displays numbers as they are entered and adjusts automatically based on the content of the cell.


When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?

first


What is a rule that assigns exactly one output value to each input value?

A function is a rule which assigns exactly one output f(x) to every input x.


A function is a rule that assigns each value of the variable to exactly one value of the dependent variable?

I found two answers for this question. A function is a rule that assigns to each value of one variable (called the independent variable) exactly one value of another variable (called the dependent variable.) A function is a rule that assigns to each input value a unique output value.


What is the relation that assigns exactly one output value to one input value?

It is a bijective function.