-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of shyam
Sent: Thursday, December 17, 2009 7:02 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1 Date at sheet2 Date at
nd TIME? is really just the fractional part of a day.
>> 39781.3706712963 is November 29, 2008 at 8:53:46AM)
>>
>> The reason that this is important is that if you want to find
>> the most recent date, you really just need to look for the
>> largest number.
>>
>> t
number.
>
> try: =MAX(A2:G2) in row 2 and copy it down.
> be sure to change the cell formatting to Date format.
>
> Is this what you were trying to do?
>
> Paul
> --
> *From:* shyam
> *To:* MS EXCEL AND VBA MACROS
> *Sent:* Thu, Dec
___
From: shyam
To: MS EXCEL AND VBA MACROS
Sent: Thu, December 17, 2009 8:32:23 AM
Subject: $$Excel-Macros$$ Concatenate after checking all cell
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at
sheet5 Date at sheet6 Concatenate(Fina
Date at sheet1 Date at sheet2 Date at sheet3 Date at sheet4 Date at
sheet5 Date at sheet6 Concatenate(Final po Date)
0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan-00
0-Jan-0029-Nov-08
0-Jan-000-Jan-000-Jan-0029-Nov-08 0-Jan