dd/mm/yy HH:MM:SS

[tinmar]

I need to grab some data from a list which contains the dates in the form dd/mm/yy HH:MM:SS, however I need to Vlookup against the dd/mm/yy only, how do I get rid of the HH:MM:SS. I have tried to change the format and obviously this aint gonna work.

please help

 

[GlennUK]

Use INT(cellref) to get just the date part of another cell.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlbo]

=vlookup(INT(cell_Ref),Data_Range,Offset,FALSE)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

FTI:

Why do Dates and Times seem to be so much trouble? faq68-5827

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}