Hello I am here again for small formula, I need one less entry
A1 = Start Month (1 Feb. 2008) I need auto entry last day of mont in cell E1
Tnanks in advance
Hello I am here again for small formula, I need one less entry
A1 = Start Month (1 Feb. 2008) I need auto entry last day of mont in cell E1
Tnanks in advance
Try this formula in E1
=DATE(YEAR(A1),MONTH(A1)+1,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks