How to Display "Late" When an Excel Date is Overdue
Question details
The user needs to automatically display the text "Late" in a specific column when one date is more than 14 days later than a baseline date.

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Tracking project deadlines, overdue tasks, or late shipments using date difference comparisons.
- Observed behavior
- Requires a formula in column BU that evaluates the date difference between column A and column N, returning "Late" if the difference exceeds two weeks.
Ensure that the cells in your target columns (e.g., column A and column N) are properly formatted as Dates. Text strings that look like dates can cause calculation errors.
Use the IF Function for Calendar Days
This is the standard method. It calculates the exact number of calendar days between two dates and flags entries exceeding a two-week (14-day) threshold.
The most straightforward way to handle date differences in spreadsheets is to subtract the earlier date from the later date. Excel and WPS Spreadsheet store dates as serial numbers, so simple subtraction yields the number of days between them.
Click on cell BU2 (or wherever you want the result to appear).
Type the formula: =IF(A2-N2>14, "Late", ""). This checks if the value in A2 minus the value in N2 is greater than 14.
Press Enter. If the date in A2 is more than 14 days past N2, "Late" will appear. Otherwise, the cell will remain blank.
Click and drag the small square (fill handle) at the bottom right corner of cell BU2 down the column to apply this logic to the remaining rows.

Use NETWORKDAYS for Business Days
Use this method if your two-week threshold strictly refers to business days, meaning you want to exclude weekends and specified holidays from the calculation.
Track Deadlines Easily with WPS Spreadsheet
WPS Spreadsheet offers powerful, built-in date functions and conditional formatting tools to help you manage schedules and highlight overdue tasks effortlessly. It flawlessly supports all standard spreadsheet formulas, ensuring your task-tracking workflows remain fast and reliable.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your deadline tracking workbook.
- 2. Apply the date formula: Click the target cell and enter the formula =IF(A2-N2>14, "Late", ""), then press Enter.
- 3. Highlight late items automatically: Select the result column, go to the 'Home' tab, and click 'Conditional Formatting'.
- 4. Set the formatting rule: Choose 'Highlight Cells Rules' > 'Equal to', type 'Late', and pick a red highlight style to make overdue items stand out.

Frequently Asked Questions
Why is my formula returning an error instead of "Late"?
This usually happens if the data in column A or N is formatted as text instead of a valid date. Select the columns, right-click, choose "Format Cells," and ensure "Date" is selected. You may need to re-enter the dates if they were pasted as raw text.
How do I display "On Time" instead of leaving the cell blank?
You can modify the 'value_if_false' portion of your IF formula. Simply change the empty quotation marks at the end to "On Time". The new formula will look like this: =IF(A2-N2>14, "Late", "On Time").
What happens if the deadline cell in column N is empty?
If column N is blank, the spreadsheet treats it as a zero value (representing a date in the year 1900), which will result in a huge date difference and incorrectly trigger a "Late" result. To prevent this, use a nested IF to check for blanks: =IF(N2="", "", IF(A2-N2>14, "Late", "")).
Can I automatically color the cell red if it says "Late"?
Yes, using Conditional Formatting. Select your column, navigate to the Home tab, click Conditional Formatting > Highlight Cells Rules > Equal To. Type "Late" in the box and select a red fill format.




