How to use EDATE Function in Excel

Опубликовано: 02 Ноябрь 2024
на канале: Excel With Ravi
2,345
46

In this video we learn how to use EDATE Function in Excel.

EDATE:- You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the future, and a negative value for dates in the past.
Syntax
EDATE(start_date, months)

The EDATE function syntax has the following arguments:

Start Date:- Required. A date that represents the start date.

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.


In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @ https://chat.whatsapp.com/BymUIDEt3ME...
-----------------------------------------------------------------------------------------------------------------------

अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !

#EDATE #Calculate_Due_Date #Date_Function #DateFormula