Find first and last date of any month

You can find the first date of any month in three different conditions mentioned below:

First Day of any month - 

Enter Month and Year in "cell D4" e.g. December-2014 and use the below formula in "cell E4" to get the first date of the month

=DATE(YEAR(D4),MONTH(D4),1)


Enter any date value in "cell D5" e.g. 4-Apr-2014 and use the below formula 
in "cell E5" to get the first date of the month

=DATE(YEAR(D5),MONTH(D5),1)


Enter any Month name in "cell D6" e.g. February and use the below formula 
in "cell E6" to get the first date of the month

=(D6&"/1")+0


Enter any Year in "cell D7" e.g. 2014 and use the below formula 
in "cell E7" to get the first date of the month

=DATE(D7,1,1)


Below is the screenshot for the above formulas :

Last Day of month - 

Below formula is used to get the last date of any month, based on the selected date

=DATE(YEAR(B3),MONTH(B3)+1,0)

here for e.g., if we say B3 = 5/6/2014, then output of above formula will be 5/31/2014

Last Day of Previous month - 

Below formula is used to get the last date of previous month, based on the selected date

=DATE(YEAR(B3),MONTH(B3),0)

here for e.g., if we say B3 = 5/6/2014, then output of above formula will be 4/30/2014

These formulas can be used in different conditions where formula based data analysis is required and the data keeps changing based on different dates.

e.g. Case :
You can find the first date and keep adding that date by 1 to get the next dates of the month.

Done......