EDATE Function in Excel | Formula | How to Use EDATE in Excel?
In this video on EDATE Function in Excel, here we discuss the EDATE Formula and how to use EDATE function in excel along with excel examples.
𝐄𝐃𝐀𝐓𝐄 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧
------------------------------------------
EDATE in excel is used to get a date on the same day of the month, past or future x months.
EDATE is an integrated function in MS Excel. EDATE Function falls within Excel's DATE and TIME category.
𝐄𝐃𝐀𝐓𝐄 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
----------------------------------------
Below is the EDATE Formula in Excel.
=EDATE (start_date, months)
𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
----------------------
Start_date = Start date as a valid Excel date.
months = Number of months before or after start_date.
𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫 𝐰𝐡𝐢𝐥𝐞 𝐮𝐬𝐢𝐧𝐠 𝐄𝐃𝐀𝐓𝐄 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
--------------------------------------------------------------------------------------------------------
#1 - The EDATE Excel Function's 2nd parameter must be a positive number.
#2 - If start date is an invalid date, # VALUE error is returned by EDATE in excel.
#3 - The value is truncated to be an integer if months is not an integer.
#4 - As sequential serial numbers, Microsoft Excel stores dates so that they can be used in calculations.
To know more about 𝐄𝐃𝐀𝐓𝐄 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥, you can go to this 𝐥𝐢𝐧𝐤 𝐡𝐞𝐫𝐞:- https://www.wallstreetmojo.com/edate-...
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - / @wallstreetmojo
