remove time from date in excel using formula code example Example: remove / from date in excel =TEXT(B3,"mmddyyyy")