1 January

Top Tip on 21st October 2016

Excel Date formulas
Last day in month =EOMONTH(B6,0) – Use zero to give last day of month as per cell B6.
1=next month or -1 previous month