How to calculate expiration dates By using IF Formula
How to calculate Membership expiration dates By using IF Formula
Here we will learn IF FORMULA, how we can use it, Let's start
We have a data here in which we are going to discuss 8 different membership expiration data.
We have a membership in this data which is Renew every year, We have to find out what is the status of which membership, has expired or is going to happen.
In the First Column (First Name), We have name of persons.
In the second column (Renewed), the date in which we got Renew done last time.
In the third column (Expires), we are assuming that all memberships have an expiry date of one year.
In the fourth column (Today), we have made today's date the base, on the basis of which we will calculate.
In the Fifth column (Days left), we subtract today's date from the expiry date to find out how many days are left.
In such a situation, everyone's days have come to the left days column.
F2 Cell =IF(E2<0,"Expired",IF(E2<30,"Expiring soon",""))
IF Formula Syntex =if(logical_test,[value_if_true],[value_if_false])
For status Column Answer, we will use a simple nested if formula. If days left is less than zero, the membership is expired. Otherwise, if days left is less than 30, the status should be "expiring soon". Otherwise, the status is nothing.
Now you must have understood that how to calculate expiration dates.
You can easily work on Excel by doing IF FORMULA like this.
