title: How do I change the date format in the formula bar to match cells in excel
body: <p>I am trying to format a date column so i can compare another list and sort for duplicates. The format I need to match is mm/yyyy. I have changed the format through a custom format however the formula bar still shows m/dd/yyyy even though it shows correctly in the cell. Because of this, the dup function (count if) is checking the formula bar but not what shows in the cell. I would assume that this is a simple fix? Any help is much appreciated.  </p>