October 6, 2015
Hi fellow Excel Addict,
I don't claim to be a great photographer but I was out for a walk with my wife on Sunday and the scenery was so beautiful I had to take these pictures (with my cell phone). Since many of my readers love to see pictures of Newfoundland, I thought I should share these with you.
Thanks for being an 'Excel Addict'. This is the first of two newsletters that I will be sharing with you this week.
My 'Excel in Seconds' tips:
"What you think, you become.
What you feel, you attract.
What you imagine, you become."
Got an Excel tip that you use that can be carried out in less than a minute?
Please share it with me so I can use it in this newsletter to help others 'excel in seconds'. Be sure to put 'EXCEL IN SECONDS' in the subject line of your email.
Hope you enjoy this today's tip.
Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
You can access even more tips on my website by going to my members' page.
Extract The Year, Month, or Day From A Date
If you you use dates in Excel, you've probably also needed to refer to just the year, month or day from a date in another cell. The solution is simple.
Lets say that cell A1 contains the date July 10, 2015 (entered as 10/7/2015 or 7/10/2015 depending on your date system). You want to extract the year (i.e. 2015) 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)
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630