Forum Discussion
I need help writing a complex formula involving dates
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 Replies
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
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
