Urgent
 

Dear All,

A B C D E
Date Time Date Time Output
04.07.08 9:18:56 AM 01.08.08 7:41:33 PM
04.08.08 9:18:56 PM 01.08.08 7:41:33 PM
24.08.08 10:05:03 AM 22.08.08 12:13:30 PM

Check date time in column A, B, C & D if date & time of column C & D is
greater that date time of column A & B I should get "No" else "Yes" in column
E.

TIA

Urgent
 

Kiran,

Can you have date AND time in column?
Assuming you have one in Col A and the other in Col B then in C2 you can enter
=If(A2B2,"Yes","No")

You can enter in F2
=A1+B1
and in G2
=C1+D1
to combine the date & time

Then your formula will become
=IF(F2G2,"Yes","No")

Let me know how it works out.

Makse sure that A & C have dates and D & E have times...
I had to retype the values provided by you as they did not automatically
convert to date in A & C

"kiran" wrote:

Dear All,

A B C D E
Date Time Date Time Output
04.07.08 9:18:56 AM 01.08.08 7:41:33 PM
04.08.08 9:18:56 PM 01.08.08 7:41:33 PM
24.08.08 10:05:03 AM 22.08.08 12:13:30 PM

Check date time in column A, B, C & D if date & time of column C & D is
greater that date time of column A & B I should get "No" else "Yes" in column
E.

TIA

Urgent
 

By mistake typed A1... etc
Replace by A2,..

assuming row 1 has headers
You will have to copy the formulae down

"kiran" wrote:

Dear All,

A B C D E
Date Time Date Time Output
04.07.08 9:18:56 AM 01.08.08 7:41:33 PM
04.08.08 9:18:56 PM 01.08.08 7:41:33 PM
24.08.08 10:05:03 AM 22.08.08 12:13:30 PM

Check date time in column A, B, C & D if date & time of column C & D is
greater that date time of column A & B I should get "No" else "Yes" in column
E.

TIA

Urgent
 

Hi Kiran,

Provided they are real dates and times and not text, this should work.
=IF(C1+D1A1+B1,"NO","YES")

put it in E1 and drag down as far as needed.

HTH
Martin

"kiran" wrote:

Dear All,

A B C D E
Date Time Date Time Output
04.07.08 9:18:56 AM 01.08.08 7:41:33 PM
04.08.08 9:18:56 PM 01.08.08 7:41:33 PM
24.08.08 10:05:03 AM 22.08.08 12:13:30 PM

Check date time in column A, B, C & D if date & time of column C & D is
greater that date time of column A & B I should get "No" else "Yes" in column
E.

TIA