Or just:
=DATE(YEAR(A1),MONTH(A1)+1,0)
Gary''s Student wrote:
If the date is in A1, then enter:
=DATE(YEAR(A1),MONTH(A1)+1,1)-1 in a cell to get the last day of that month
--
Gary''s Student
"comotoman" wrote:
i know how to find the first day of a month but how can i find the last
day of a month?
October 2005 First day is Sat 1st. I also need the formula to find Mon
31st.
Thanks
--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=477256
--
Dave Peterson