About Us

Christopher Naveen[_2_]

Hi,

I Have 4 cols which has dates, i want to find out the latest date in that 4
cols. Can anyone help me on this.

Chr

Jacob Skaria

Try

=MAX(A:D)
(and format the formula cell to excel date format)

If this post helps click Yes
---------------
Jacob Skaria

"Christopher Naveen" wrote:

Hi,

I Have 4 cols which has dates, i want to find out the latest date in that 4
cols. Can anyone help me on this.

Chr

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date comparison	oldLearner57	Excel Discussion (Misc queries)	2	March 29th 09 04:45 PM
Date comparison	TomD	Excel Discussion (Misc queries)	4	February 20th 07 10:37 PM
date comparison help	CathyZ	Excel Discussion (Misc queries)	5	May 4th 06 11:53 AM
Date comparison	Darkdrew	Excel Worksheet Functions	7	March 23rd 06 04:22 PM
Date comparison	Jonibenj	Excel Discussion (Misc queries)	6	October 23rd 05 08:34 PM

Menu

About Us