How do you grab the date?

[entauri]

Hi,

How would you get Column B from Column A?

Col A	Col B
List	Date
15-Nov-17	15-Nov-17
Bread	15-Nov-17
Apples	15-Nov-17
Bananas	15-Nov-17
16-Nov-17	16-Nov-17
Eggs	16-Nov-17
Bread	16-Nov-17
17-Nov-17	17-Nov-17
Bananas	17-Nov-17

<tbody>
</tbody>

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
1	List	Date
2	15-Nov-17	15-Nov-17
3	Bread	15-Nov-17
4	Apples	15-Nov-17
5	Bananas	15-Nov-17
6	16-Nov-17	16-Nov-17
7	Eggs	16-Nov-17
8	Bread	16-Nov-17
9	17-Nov-17	17-Nov-17
10	Bananas	17-Nov-17

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:70px;"><col style="width:70px;"></colgroup><tbody>
</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.