How To Use VBA DateDiff Function In Excel
Oct 23, 2020
The DateDiff function in Excel VBA can be used to get the number of days between two dates.
How To Use VBA Delay a Macro In Excel
Oct 23, 2020
To execute a sub in Excel VBA after a specific time, use onTime, Now and the TimeValue function.
How To Use VBA Compare Dates and Times In Excel
Oct 22, 2020
This example teaches you how to compare dates and times in Excel VBA.
How To Sort Birthdays (Dates) In Excel
Oct 17, 2020
Below we will look at a program in Excel VBA that sorts birthdays to months first and days second (so we ignore years).
How to Use Tasks on Schedule In Excel VBA
Oct 16, 2020
Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green.