I am trying to work on a project that has thousands of dates that i need to set up as MM/DD and currently i have them as MM/DD/YY. Is there a function on excel that helps me do that automatically or do i have to do it manually??
Also, i need to create a column that has 10 days prior to the MM/DD, is there a formula that i can use to do this? Otherwise i have to go a manually change the date for about 8,000 contacts.