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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to return tomorrow's date.	Shadyhosta	New Users to Excel	6	April 4th 23 10:20 AM
Date formula	Mike R	Excel Discussion (Misc queries)	7	January 20th 05 10:07 PM
Excel: Is there a way to calculate the date as week of month?	debra adams	Excel Discussion (Misc queries)	2	January 3rd 05 09:39 PM
Date Formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 17th 04 07:25 PM
How can I format a cell so date field only displays the Month?	tk_2u	Excel Discussion (Misc queries)	3	December 4th 04 12:54 AM

All times are GMT +1. The time now is 03:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us