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