Tuesday, 27 March 2012

Calculate first day in month relative to a date

Type:   =EOMONTH(A1,2)+1

Where A1 represents the date, 2 represents the number of month from that date.

1 comment:

  1. Very handy formula, this is going to save me a lot of time

    ReplyDelete