Top Tip on 21st October 2016 Coopa Friday, 21st October 2016 TweetPinShare0 SharesExcel 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 TweetPinShare0 Shares