XLA routines: EE_LastDayOfMonth
EE_LastDayOfMonth takes a date and returns the last day of the month that the date is in.
Function EE_LastDayOfMonth(dt As Date) As Date 'Takes a date and returns the last day of the month 'http://excelexperts.com/xla-routines-eeLastDayOfMonth for updates on this function EE_LastDayOfMonth = DateAdd("d", -1, EE_FirstDayOfMonth(DateAdd("m", 1, dt))) End Function
»
- Nick's blog
- Login or register to post comments
- 2602 reads
Recent comments
5 years 1 week ago
5 years 39 weeks ago
5 years 51 weeks ago
6 years 1 week ago
6 years 2 weeks ago
6 years 8 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago
6 years 16 weeks ago