First and Last Day of Month?

  • Thread starter Thread starter Anthony C
  • Start date Start date
A

Anthony C

Is there a quick and easy way to pull the first and last day of a given
month? I'm about ready to create a table and type in month values 1-12 and
their corresponding # of days, but figured that there must be a better way.

Thank you!
-Anthony
 
First day of month:
=Date() - Day(Date()) + 1

Last day of month:
=DateSerial(Year(Date()), Month(Date()) + 1, 0)
 
Back
Top