I am no excel whiz kid.......so to make a long story short.
Downloaded some data from a database and excel dates are in 2 formats.....mm/dd/yyyy & mm-dd-yyyy. Tried to apply the =Text( A1, "mm/dd/yyy") formula did not help.
Tried the : format cells----->custom-----> .....etc, did not work
Looked over google did not really find anything that can help....
Any help appreciated or the MD is gonna fry my ass.......
| +277 | Return Rates For Interns Are Falling? | 112 | 6m |
| +123 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 13 | 1h |
| +114 | I am a drunk MD AMA | 39 | 1d |
| +71 | UBS Offer Day | 27 | 4m |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 2d |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 5d |
| +43 | No return so what are the options left | 31 | 1h |
| +41 | WF Return offers | 28 | 2h |
| +40 | I hate Wells Fargo | 6 | 17h |
| +34 | No return offer - feeling like a failure is an understatement | 14 | 23h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
are you sure excel is recognizing either format as actual dates or is it recognizing it as text? You might want to take one of them and manually type in a date in one of the cells and then see if your formula works.
Copy, paste special-format.
ok patrick you were right........so i basically copied the whole column and pasted them in as values only.....still the dates with the mm-dd-yyyy stayed as they are ( i assume because they are text right ? ) , went into format cells ........date......still nothing changed
When i pasted special by the way the dates with dd/mm/yyyy changed into numbers.....then i couldd reformat them...this thing is driving me mental
Thanks for both your help though
Download SAS and teach yourself how to program. Wins every time.
Quia suscipit est natus. Placeat in impedit architecto aut. Eveniet aut incidunt laboriosam. Aperiam consectetur ab ut quisquam repudiandae corporis in.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...