31 Dec -> 31 Marc ->30Jun -> 30 Sept ->31 Dec Edate doesnt work as it: 30 Sept ->30 Dec
M mrdue New Member Mar 24, 2022 #1 31 Dec -> 31 Marc ->30Jun -> 30 Sept ->31 Dec Edate doesnt work as it: 30 Sept ->30 Dec
V vletm Excel Ninja Mar 24, 2022 #3 mrdue Have You read EDATEs syntax? Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. If You would like to get always the last date of month then use EOMONTH-function.
mrdue Have You read EDATEs syntax? Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. If You would like to get always the last date of month then use EOMONTH-function.