I need help writing a complex formula involving dates

[Deleted]

Hello! 

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. 

I am currently using microsoft excel on my mac 

I appreciate your help. 

Jessika 

[#2]

Hi

Format a date the way you want

Change the date system, format, or two-digit year interpretation

Your formula is a simple subtraction:

=A1-10

[#3]

Hi Jessika,

Simply, you have an option in Excel to change the date format as you want.

Just highlight the column of dates, and then press Ctrl+1 to open the Format Cells dialog box.

In the Format Cells, select Custom, and replace what is in the Type box with this format:

MM/DD

 After that, hit OK.

With regards to the formula you asked to get 10 days prior to the MM/DD, please try this one and find it in the attached file.

=A2-10

Hope that helps