Using =EOMONTH(O2,0) returns the last day of the month of O2.
=EDATE(EOMONTH(O2,0)+1,-1) returns the first day of the month of O2
Using =EOMONTH(O2,0) returns the last day of the month of O2.
=EDATE(EOMONTH(O2,0)+1,-1) returns the first day of the month of O2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks