I have a Column (let's say Column 'A') that store data such as:-
A1 : Aug 04-19:30
A2 : Jul 30-19:30
A3 : Aug 05-17:00
etc...
I want to store data in Column 'B' the DATE portion (the FIRST portion BEFORE the minus sign in Column 'A').
PROBLEM :
How to make Column 'B' store REAL DATEs that can be SORTED ?
Pls HELP !!!
A1 : Aug 04-19:30
A2 : Jul 30-19:30
A3 : Aug 05-17:00
etc...
I want to store data in Column 'B' the DATE portion (the FIRST portion BEFORE the minus sign in Column 'A').
PROBLEM :
How to make Column 'B' store REAL DATEs that can be SORTED ?
Pls HELP !!!