Microsoft Office Tutorials and References
In Depth Information
Using Date Math
Figure 9.18.
Figure 9.18. When a formula refers to cells with different formats, the res-
When a formula refers to cells with different formats, the res-
ulting cell s format varies depending on which cell was mentioned first or
ulting cell s format varies depending on which cell was mentioned first or
last.
last.
The resulting automatic format does not appear to follow any pattern. When
you use an equal sign, either the format is copied from the first or the last
cell referenced. When you use a plus sign, the format sometimes comes from
the second, first, or last reference, and sometimes the format is a mix of two
references.
If your formula is going to refer to multiple cells with different formatting,
start the formula with an equal sign. Refer to the cell with the desired cell
format first, but accept that you might have to explicitly format the res-
ulting cell.
Using Date Math
Dates in Excel are stored as the number of days since January 1, 1900. For
example, Excel stores the date Feb-17-2015 as 42052. In Figure 9.19 , cell E1
contains the date. Cell E2 contains the formula =E1 and has been formatted
to show a number.
Search JabSto ::




Custom Search