Calculate the period between two dates to get months and days
-
- PlatinumLounger
- Posts: 4912
- Joined: 31 Aug 2016, 09:02
Re: Calculate the period between two dates to get months and days
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?
-
- 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
I also removed "As String" from the first line.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4912
- Joined: 31 Aug 2016, 09:02
Re: Calculate the period between two dates to get months and days
Thanks a lot for the illustration.