How do you grab the date?

[entauri]

Hi,

How would you get Column B from Column A?

[TABLE="width: 0"]
<tbody>[TR]
[TD]Col A
[/TD]
[TD]Col B
[/TD]
[/TR]
[TR]
[TD]List
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD="align: right"]15-Nov-17
[/TD]
[TD]15-Nov-17
[/TD]
[/TR]
[TR]
[TD]Bread
[/TD]
[TD]15-Nov-17
[/TD]
[/TR]
[TR]
[TD]Apples
[/TD]
[TD]15-Nov-17
[/TD]
[/TR]
[TR]
[TD]Bananas
[/TD]
[TD]15-Nov-17
[/TD]
[/TR]
[TR]
[TD="align: right"]16-Nov-17
[/TD]
[TD]16-Nov-17
[/TD]
[/TR]
[TR]
[TD]Eggs
[/TD]
[TD]16-Nov-17
[/TD]
[/TR]
[TR]
[TD]Bread
[/TD]
[TD]16-Nov-17
[/TD]
[/TR]
[TR]
[TD="align: right"]17-Nov-17
[/TD]
[TD]17-Nov-17
[/TD]
[/TR]
[TR]
[TD]Bananas
[/TD]
[TD]17-Nov-17
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks greatly in advance!


MET

 

[Weazel]

maybe something like....

=LOOKUP(9.99E+307,$A$2:A2) in B2

 

[JoeMo]

Assuming data in col A is always either a date or text, copy B2 down. Format col B as Date.
Sheet1

	A	B
List	Date
Bread
Apples
Bananas
Eggs
Bread
Bananas

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:70px;"><col style="width:70px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]15-Nov-17[/TD]
[TD="align: right"]15-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="align: right"]15-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="align: right"]15-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="align: right"]15-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]16-Nov-17[/TD]
[TD="align: right"]16-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

[TD="align: right"]16-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]

[TD="align: right"]16-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: right"]17-Nov-17[/TD]
[TD="align: right"]17-Nov-17[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]

[TD="align: right"]17-Nov-17[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =IF(ISNUMBER(A2),A2,B1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[entauri]

Thanks a lot. I like the simplicity of the logic.

 

[JoeMo]

You are welcome - thanks for the reply.