Use Excel IF, TODAY function to check overdue status
I will explain how to calculate excessive number of days by checking the past, the current settlement day ratio by combining IF and TODAY functions.
To check past, present, furture
1. First, create the following table.
Explanation: I entered the price and excessive number of days in the column for price settlement day
2. Formula
B2: B7 After selecting the cell, enter the following formula in cell B2, then press Ctrl + Enter. (Cells that selected mathematical expressions are automatically entered)
=IF(A2>=TODAY(),IF(A2=TODAY(),"today","settlement day"),"overdue")
Explanation: Using the TODAY () function for settlement day, we entered text to be able to output the settlement day, overdue, today.
3. Check the status result
Today is August 23, 2018. (The date when I created blog posting)
Based on the present day in the past it is output as "settlement day" and today we can confirm that "Today" will be output in the future as "overdue".
Next, let's confirm that overdue is several days compared to settlement day
6. Number of days exceeding formula
C2:C7 After selecting the cell, enter the following formula and execute it with Ctrl + Enter key.
=TODAY()-A2
** After format formula, format cell> Display format> Change to numeric value
7. Confirm result
You can check excessive days.
Posting by Excel Inside
0 댓글