Finding the last day of a month
 

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

Finding the last day of a month
 

The 0th day of the next month is the last day of the current
month. Therefore, you can use a formula like

=DATE(2005,11,0)

to return the last day in October, 2005.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"comotoman"
wrote in
message
...

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

Finding the last day of a month
 

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

Finding the last day of a month
 

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