First & Last Day of Current Month in Excel

With help of this post you can now easily find first and last of current month

This will be determined using function EOMONTH & Today()

Syntax

EOMONTH(any_date,months)





First day of the current month                                      = EOMONTH(TODAY(),-1)+1

Last day of the current month                                       = EOMONTH(TODAY(),0)