My beginning of the month is the same formula as AliGW (only with different references). My end of the month formula is different
A B C D E 1 14/04/2016 Beginning of Month End month 2 =EOMONTH($A$1,ROWS($1:1)-2)+1 01/04/2016 30/04/2016 =EOMONTH(C2,0) 3 01/05/2016 31/05/2016 4 01/06/2016 30/06/2016 5 01/07/2016 31/07/2016 6 01/08/2016 31/08/2016 7 01/09/2016 30/09/2016
Bookmarks