How to Calculate Expiration Date in Excel
How to calculate the expiration date in Excel can be achieved in many ways. I chose a method that will be easier to execute since each part is broken up separately. I use an IF statement to determine if a date has expired and conditional formatting to highlight dates that are expired in red or green if they are still active.
Download the Excel workbook used in this video: drive.google.com/drive/folder...
Subscribe and hit the notification bell for more: tinyurl.com/mu8f835c
How do you plan on using these steps? Describe your project in the comments below, and I'll be happy to provide advice or simply share with others that might help them with their project or assignment.
Chapters:
00:00 - Intro
00:40 - Calculate expiration date
01:27 - Function to display today's date
01:48 - IF statement to determine if a date has expired
05:07 - Conditional formatting to highlight expired and active dates
06:04 - Outro
#excel #calculate #expiration #expire #formula #excel365 #excel #expiry #conditionalformatting
~-~~-~~~-~~-~
Please watch: "Excel Top 5 Flash Fill Excel"
• Excel Top 5 Flash Fill...
~-~~-~~~-~~-~
Пікірлер: 15
I am so thankful and happy I found your page!!! Great video!
Thanks for explaining each detail thoroughly and providing the Excel sheet!
@OfficeMystic
2 жыл бұрын
Thank you. I plan on supplying the workbooks moving forward.
Very helpful !
Great spreadsheet. Very complicated for me. I have been working on one I thought would be simple but I guess not for me. I need to track employee name, and the employee document expiration dates and show if the document is active or expiring in the next 30 days.
Very good Tutorial. You are the best.
@OfficeMystic
Жыл бұрын
Thanks a lot!
Great , Thank you
Excellent video, and content on your channel! You got a new fan who subscribed here, keep the uploads coming. Wish I could make this, greetings from Denmark!
@OfficeMystic
2 жыл бұрын
Thank you for subscribing! I'm glad the video was helpful.
Great video, how do i use number of years instead of number of days to calculate the expiry date?
@OfficeMystic
Жыл бұрын
In column D (Expiration Date) you can multiply "$C$1" by 365 and then change cell C1 to number of years. It's not going to take into account leap years though, but being off by one day may not be a big deal. Example: =B3+($C$1*365)
Very nicely done! Informative and to the point. Thanks so much for your upload mate. Which MS Office do you use or you think is the best? Take it easy and have a lovely day 🙂
@OfficeMystic
2 жыл бұрын
I'm glad you found it helpful! I use Excel 365, if the subscription isn't a problem I would go with 365, since it has all the latest features like XLOOKUP, XMATCH, and others that are only available in 365. If you have suggestions for other videos let me know!
How does it know it's days and not years? I need to add 5 years to a date and not sure how!