|
TheExcelAddict.com
Microsoft Excel 'Quick Tip'
Extract The Year, Month, or Day From A Date
Do you use lots of dates in Excel? If you do you probably have
needed to use the year, month or day referred to in a date cell
in a separate cell. The solution is simple.
Lets say that cell A1 contains the date July 21, 2004 (entered as
21/7/2004 or 7/21/2004 depending on your date system). You want
to extract the year (i.e. 2004) from that date and put it in cell
C1. Simply enter the formula =YEAR(A1) in cell C1. Same thing for
month and day. Use =MONTH(A1) or =DAY(A1).
Why not print (CTRL+P) this tip and
share it with your friends and associates?
|
Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © All Rights Reserved by
|
Close this window
|