Calculate the period between two dates to get months and days

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Calculate the period between two dates to get months and days

Post by YasserKhalil »

Thank you very much. Did you modify only the last line of the UDF `MonthDayDiff = Array(months, days)` or there are other modifications in the new UDF?

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Calculate the period between two dates to get months and days

Post by HansV »

I also removed "As String" from the first line.
Best wishes,
Hans

YasserKhalil
PlatinumLounger
Posts: 4912
Joined: 31 Aug 2016, 09:02

Re: Calculate the period between two dates to get months and days

Post by YasserKhalil »

Thanks a lot for the illustration.