83
edits
Excel Data Quality Toolkit: Difference between revisions
→Year, Month, and Day Values Do Not Match Date
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 55: | Line 55: | ||
'''Solution:''' Avoid this problem by letting Excel calculate year, month, and day for you using these formulas where A1 is the event date. | '''Solution:''' Avoid this problem by letting Excel calculate year, month, and day for you using these formulas where A1 is the event date. | ||
=YEAR(A1) | =YEAR(A1) | ||
=MONTH(A1) | |||
=MONTH(A1) | |||
=DAY(A1) | =DAY(A1) | ||