1. Question 3: You are going to create a macro described as below.

   Requirements:

2. Create a button that will prompt a user to enter the date on which an assignment is due and will then display a message showing the number of days until this due date if it is in the future. If the date entered is in the past, the message box will show Your assignment is overdue. If the date entered is the date today, this new macro should display a message Your assignment is due today!

3. (Hint: Use a built-in function in Excel, InputBox, for the entering of date. Do not use macro recorders to create the macros.)