info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Date problem
14 views
Skip to first unread message
Norbert
Nov 18, 2021, 7:25:33 AM11/18/21
to
I am receiving a report as txt file. After importing it into Excel I have the date
separated in 3 columns (as it is separated by blanks: 1 Oct 21)
Column A: numbers: from 1 to 31
Column B: text: Jan, Feb, Mar, .....
Column C: numbers: like 21 for the year
I need to get the 3 values together to form a date which I can then sort by.
I tried
=Concatenate(A1,"-",B1,"-",C1)
but the result is a text and not a date
I don't know how to transform the text: '1-Oct-21
into a proper date format: 01-10-2021
Any help is appreciated.
Regards,
Norbert
separated in 3 columns (as it is separated by blanks: 1 Oct 21)
Column A: numbers: from 1 to 31
Column B: text: Jan, Feb, Mar, .....
Column C: numbers: like 21 for the year
I need to get the 3 values together to form a date which I can then sort by.
I tried
=Concatenate(A1,"-",B1,"-",C1)
but the result is a text and not a date
I don't know how to transform the text: '1-Oct-21
into a proper date format: 01-10-2021
Any help is appreciated.
Regards,
Norbert
Claus Busch
Nov 18, 2021, 7:31:37 AM11/18/21
to
Hi Norbert,
try:
=DATE(C1,MONTH(B1&"1"),A1)
Regards
Claus B.
--
Windows10
Microsoft 365 for business
=DATE(C1,MONTH(B1&"1"),A1)
Regards
Claus B.
--
Windows10
Microsoft 365 for business
Norbert
Nov 18, 2021, 10:27:17 AM11/18/21
to
Hi Claus!
thank you very much!
Works!
Regards,
Norbert
thank you very much!
Works!
Regards,
Norbert
0 new messages