How to calculate expiry date in Microsoft Excel
Рет қаралды 39,507
Жыл бұрынin this tutorial I have explained how to calculate expiry date of an item in Microsoft Excel. whether you are doing medical insurance or vehicle insurance I want to calculate the expiry date and the number of days left in the expiry we can do this calculation in Excel. EDATE function is go to option when a maturity date expiry date has to be calculated in Excel. EDATE function actually calculates in date falling at the same date after specific time period.
#edate #EDATEFUNCTION
#expirydate
@suphansathong-in4392 2 ай бұрын
Thank you so much.
@BonBonTatinesha 4 ай бұрын
What if I want to create a column that generates the exp date based on the day in the previous column and then changes color based on how close we are to the date? For example, I have 2 cells with the completion date for 3/2024 and 4/2024 respectively. I want to create a second column to autogenerate a 1-year expiration date, so 3/2025 and 4/2025. I also want all dates generated within this column to be green, with the exception of being within 1 month of exp date (amber) and past the exp date (red).
@techtimes1985 4 ай бұрын
That's a great Idea, I have never tried it but conditional formatting can be used to show the changes occured over times in a data.
@teddyw.charawa8989 3 ай бұрын
M following but failing to calculate date well.
@techtimes1985 3 ай бұрын
What problem do you face?
@aceferrer2537 4 ай бұрын
How about if the time is in days not months?
@techtimes1985 4 ай бұрын
You can use day function
@fariesyouszaini8962 8 ай бұрын
how if i want count in days ? not months
@techtimes1985 8 ай бұрын
It's explained in the video
@rmsyster 11 ай бұрын
comma does not work with my excel
@techtimes1985 11 ай бұрын
Which version of office you are using?
Jopa Excel
Рет қаралды 46 М.
Chester Tugwell
Рет қаралды 8 М.
Rob Hambleton
Рет қаралды 1 МЛН
Learn for Future
Рет қаралды 170 М.