filmov
tv
Create Expired Date Using the EDATE function in Excel #excel #shorts #exceltips

Показать описание
How to Create Expired Date Using the EDATE function in Excel.
In this video, I use the EDATE function in Excel to create the expired date.
What is the EDATE function in Excel?
The EDATE function in Excel is used to calculate a date that is a specified number of months before or after a given start date.
Syntax:
EDATE(start_date, months)
Start_date (Required): A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions.
Months (Required): The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions, please write in the comments below.
------------------------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv
In this video, I use the EDATE function in Excel to create the expired date.
What is the EDATE function in Excel?
The EDATE function in Excel is used to calculate a date that is a specified number of months before or after a given start date.
Syntax:
EDATE(start_date, months)
Start_date (Required): A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions.
Months (Required): The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions, please write in the comments below.
------------------------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv