Excel Milestone Days
June 16, 2020
You'll get my next newsletter on June 30th -- we're on the summer schedule now, with a newsletter every 2 weeks.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Long ago, on July 6, 2009, I was entering dates in Excel, and noticed that the current date had the number value of 40000. (In Excel's default date system, day 1 is on Jan 1, 1900)
That seemed like quite a milestone, so I wrote a blog post about it. Now, almost 4000 more days have passed, and this Thursday, June 18, 2020, is day 44000 in the Excel date system. Except on a Mac -- its day 0 is Jan 1, 1904. Exciting, right? ;-)
There's a Golf Tee Off Times workbook on my Contextures site, in which you
I'm sure you could adapt this technique to assign people to other types of schedules. Who's working each day of the week? Which employees are on the morning shift?
Go to my Contextures site, to watch a short video that shows how the tee off times file works. There are written steps too, and download the sample file.
Here are a few Excel-related articles that you might find useful or interesting.
Power BI -- Sign up for the free Power BI Global Virtual Conference, that runs today and tomorrow (Tue Jun 16-17, 2020) from 1 - 9 PM EDT, both days. You'll have to register (free) to see the full agenda, including a few Power Query sessions. Sorry for the short notice! (Level - Int/Adv)
Charts: Instead of a crowded line chart, use one of these alternatives from Robert Mundigl - a band chart (no VBA) or an interactive chart that highlights one line.. (Level - Int/Adv)
Our garden isn't too big this year, but it looks like we'll get a good harvest from one of our tomato plants -- Tumbling Tom. This is a determinate tomato plant, so it's bushy in shape, and has an early crop. We've never had this type of tomato plant before, but so far, so good!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200616ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: June 26, 2020 11:14 AM