Remember Me?

#1
October 28th 04, 06:01 PM
 Steve F. Posts: n/a
Return the end of month date from a date

Is there a formula I can use that can return the last day of the month from a
date entered in another cell? It needs to work for all months, regardless of
length of month.

Ex.: 11/12/2004 is entered in A1. I want B1 to return 11/30/2004.

#2
October 28th 04, 06:04 PM
 Bob Phillips Posts: n/a

=date(year(a1),month(a1)+1,0)

--

HTH

RP

"Steve F." <Steve wrote in message
news
Is there a formula I can use that can return the last day of the month

from a
date entered in another cell? It needs to work for all months, regardless

of
length of month.

Ex.: 11/12/2004 is entered in A1. I want B1 to return 11/30/2004.

#3
October 28th 04, 06:11 PM
 Frank Kabel Posts: n/a

Hi
=DATE(YEAR(A1),MONTH(A1)+1,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve F." <Steve schrieb im Newsbeitrag
news
Is there a formula I can use that can return the last day of the

month from a
date entered in another cell? It needs to work for all months,

regardless of
length of month.

Ex.: 11/12/2004 is entered in A1. I want B1 to return 11/30/2004.

#4
October 28th 04, 06:17 PM
 mzehr Posts: n/a

Hi Steve,
If you don't have the Eomonth Function (in Analysis Toolpack) available to
you use :
=DATE(YEAR(A1),MONTH(A1)+1,0)

"Steve F." wrote:

Is there a formula I can use that can return the last day of the month from a
date entered in another cell? It needs to work for all months, regardless of
length of month.

Ex.: 11/12/2004 is entered in A1. I want B1 to return 11/30/2004.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mike R Excel Discussion (Misc queries) 7 January 20th 05 11:07 PM debra adams Excel Discussion (Misc queries) 2 January 3rd 05 10:39 PM Shadyhosta New Users to Excel 5 December 26th 04 08:15 PM Robyn Bellanger Excel Discussion (Misc queries) 2 December 17th 04 08:25 PM tk_2u Excel Discussion (Misc queries) 3 December 4th 04 01:54 AM

All times are GMT +1. The time now is 02:00 PM.