Home

I need help writing a complex formula involving dates

Deleted
Not applicable

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.

 

Format Cells - Custom.png

 

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

Get 10 days before a date.png

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies