hossam sadek
Member
Hi All
i need help with the attached sheet,i want a formula to extract the Date only from Column B to another column, to be honest, I found a way to do it but the challenge i faced that the dates formates are different some with "/" some with "" take an example the attached sheet all the dates on this sheet are January 2021 dates
so if someone can help me to suggest a formula to do that to a new column
Thanks in advance
i need help with the attached sheet,i want a formula to extract the Date only from Column B to another column, to be honest, I found a way to do it but the challenge i faced that the dates formates are different some with "/" some with "" take an example the attached sheet all the dates on this sheet are January 2021 dates
so if someone can help me to suggest a formula to do that to a new column
Thanks in advance
Attachments

8.5 KB Views: 10