Date and Time Functions – N to Z
Table of Contents How to use the NETWORKDAYS function How to use the NETWORKDAYS.INTL function How to use the NOW […]

Date and Time Functions – A to M
Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]

How to track sector performance in the stock market – Excel template
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]

Calendar – monthly view
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]

Yet another Excel Calendar
What's on this page How to use this Excel Calendar How to add events How I built this calendar Worksheet […]

Excel calendar
Table of Contents Excel monthly calendar - VBA  Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

Shift Schedule
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]