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 auto...
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