Home » Blogs » Nick's blog

XLA routines: EE_FirstDayOfMonth

Nick's picture
Submitted by Nick on 31 January, 2015 - 08:44
EE_FirstDayOfMonth takes a date and returns the first day of the month that the date is in. 
Function EE_FirstDayOfMonth(dt As Date) As Date
'Takes a date and returns the 1st day of the month
'http://excelexperts.com/xla-routines-eeFirstDayOfMonth    for updates on this function

    EE_FirstDayOfMonth = Format(Month(dt) & "/1/" & Year(dt), "mm/dd/yyyy")
End Function
»