# How to Use Formula for Past Due Date in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

In times of data sorting, we sometimes face the necessity of finding past due date. From this article, you will know about Excel formula for past due date.

For clarification, I have used a dataset containing data titled Project Name and Deadline.

## How to Use Formula for Past Due Date in Excel: 3 Ways

### 1. Using Excel TODAY Function in Conditional Formatting for Past Due Date

Use of TODAY Function is a very efficient way to separate for Past Due Date.

Steps:

• Select all the cells containing dates. Here, I have selected cells C5:C11.
• Then, choose Home from the ribbon.
• Select Conditional Formatting and New Rule sequentially.

A Dialogue box will appear.

• Select Format only cells that contain from Select a Rule Type.
• Next, From the Format only cells with, select Cell Value, less than and =TODAY() continuously.
• Afterward, select Format.Â

Another dialogue box will appear named Format Cells.

• Select the Fill tab and choose a color.
• Press OK.

• Press OK again.

Finally, the formula will be applied and the past due date will be identified.

Read More: How to Pull Data from a Date Range in Excel

### 2. Applying Excel IF & ISBLANK Functions for Past Due Date

We can also apply IF Function , TODAY function and ISBLANK function to create a formula for Â past due date.

Steps:

• Select a cell and input the formula.
• Here, I have selected D5 for the application of the formula.

The Formula here is:

`=IF(ISBLANK(C5),"", IF(C5<TODAY(),"Delayed","On Time"))`

Where, ISBLANK Function is used to check if the selected cell is blank or not. A condition is applied using IF Function which gives Delayed output for value less than today compared with the selected cell value and On Time output for the rest.

• PressÂ ENTER.

### 3. Employing Excel Combined Functions for Past Due Date

We can also employ a formula that contains both IF, TODAY & MAX Function for past due date.

Steps:

• Select a cell and write the formula.
• Here, type the following formula in cell D5.
`=IF(MAX(0,TODAY()-C5)=0,"On Schedule","Due")`

Where MAX Function returns the largest value and ignores the empty cells. A condition is applied here using IF Function where differentiating values between todayâ€™s date and the date mentioned in the cell, it will give output On Schedule or Due.

• Press ENTER.

• For the AutoFill, use Fill Handle.

## Practice Section

You can practice here for more efficiency.

## Conclusion

Every Excel formula for past due date is shown here is quite easily functional and effective. Here, you can give your feedback or further queries in the comment section.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

1. Dear Sir,
Hope you are doing well can you help me?
Please tell me formula What can i use for alert in excel.
1) How do I create a pop up alert in Excel?
2) How do I blink or flash text of a specific cell in Excel?

• Dear ATEEB,
How to create a pop-up alert in Excel

To create a pop-up alert in Excel, you can use a combination of VBA (Visual Basic for Applications) code and Excel’s event triggers. Here’s an example code snippet that you can use:

Copy and paste this code into the sheet module (e.g., press Alt+F11 to open the Visual Basic Editor, find the relevant sheet in the Project Explorer, and double-click on it to open its code window). Replace “\$A\$1” with the cell reference that should trigger the alert.

``````Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "\$A\$1" Then ' Change the cell reference to the desired cell triggering the alert
MsgBox "Alert: Cell A1 has been changed!" ' Customize the alert message as needed
End If
End Sub``````

Customize the alert message within the MsgBox function to suit your requirements. After changing cell A1, the alert message will appear.

How to blink or flash text of a specific cell in Excel

Excel does not provide a built-in feature to directly make text blink or flash. However, you can achieve a similar effect by using VBA code to toggle the cell’s font color.
In the following code, we’re toggling the font color between red and black for the specified cell (in this case, cell A1). Adjust the cell reference and customize the number of blinks and the timing (in seconds) to meet your specific requirements.
Here’s an example code snippet that demonstrates this:

``````Sub BlinkText()
Dim rng As Range
Set rng = Range("A1") ' Change the cell reference to the desired cell to blink
For i = 1 To 5 ' Number of times to blink
rng.Font.Color = RGB(255, 0, 0) ' Change font color to red
Application.Wait Now + TimeValue("00:00:01") ' Wait for 1 second
rng.Font.Color = RGB(0, 0, 0) ' Change font color back to black
Application.Wait Now + TimeValue("00:00:01") ' Wait for 1 second
Next i
End Sub``````
```