• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date format

basavarajkh

New Member
Hi

In column G some of the date formula not working

Pls help me & find the link below :


http://speedy.sh/yZYbx/W-O-Pending-for-Closure-1st-March.xlsx


Thanks


Regards

Basavaraj K H
 
Hi Basavaraj ,


That is because some of them are numeric , and some are not.


Use the following formula in G2 , and copy down.


=IF(TYPE(F2)=2,SUBSTITUTE(REPLACE(MID(F2,4,3)&F2,7,3,""),".","/")+0,F2)


Narayan
 
Back
Top