WDS2000

Posts: n/a

Min/Max formulas using cells with date format

Using a min or max formula for a range of cells that have a date format. For
example, while in F4, i create the following formula =MIN(F5:F9). If all of
the cells in the range are null, the result is 00-Jan-1900. This date
appears to be the cell default value if nothing is entered.

Is it possible to exclude null cells in the formula?

Thanks
Will

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Format cells as date	bay	Excel Discussion (Misc queries)	3	January 26th 05 05:34 PM
Date format collapses diagram	Richard H	Excel Discussion (Misc queries)	3	December 14th 04 11:08 PM
Problem with Date format from VBA code	twig	Excel Discussion (Misc queries)	3	December 7th 04 06:01 PM
Date Formatted Cells	Mike	Excel Worksheet Functions	3	December 3rd 04 05:55 PM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 08:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us