Get instant live expert help on I need help with mm/yy

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello. I need help with my function. How do i add "UDSKIFT(F4;"-";"/")" into =(DATO(VENSTRE(F4;2)+2000;MIDT(F4;4;2);HØJRE(F4;2))) I am changing date yy-mm-dd into dd/mm/yy
Solved by V. Q. in 12 mins
I need to save a excel 97-2003 file as a cvs file. But it is not keeping the excel date format of mm/dd/yy, it keeps going back to mm/dd/yyyy. Help!
Solved by K. E. in 14 mins
Hi, I need a formula to split the following : Jul 23, 2018 3:21:48 PM I need the above to be in this format dd/mm/yy. i.e. 23/07/2018
Solved by D. L. in 29 mins
I'm attempting to force my users to enter a date in a mm/dd/yy format, I do not want the information accepted unless it's entered exactly this way.
Solved by M. Y. in 17 mins
I am using Match and index function to locate interest rate in one tab by looking up the date (mm-yy). but the formula returns N/A when I use mid month date. Please Help!!!
Solved by X. W. in 28 mins