Project End Warning with & without VBA in Excel

Home More Videos

Let's say you're doing a project with a start date, a few milestones and have a deadline to meet. You wished to be warned if the present date is greater than the deadline, i. e. you are behind schedule. You can write VBA code or you can use the standard features in Excel to perform the job. Both the solutions are described here. The range Q3 or cell Q3 contains the function '=TODAY()' which gets today's date from the computer system. Therefore it's important that your system date is correct. In VBA we use the sub 'worksheet_calulate()' and the code almost resembles the If function that we use under standard working conditions. Without VBA we use the IF and TODAY functions of Excel to compare two dates and based on the result we do a conditional formatting to create our warning system.

Watch the video on youtube