Funcky Date Conversion to "Text"

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,720
I have an excel import template for a software program the company I work for uses. The Software import template uses an unusual date format

01/25/2018 would be 118
10/01/2017 would be 1017

I am trying to pull data from one of my spreadsheets to past into their template, but my spreadsheet uses the standard date formats. So I need to convert my dates to their format.

I cant seem to come up with a formula to convert my date fields into their format. my spreadsheet is using m/dd/yyyy

Their field on their excel import template is a "General" field.

anyone have a suggestion other than changing my spreadsheet date format. If I asked my users to start entering dates that the software uses, I would laughed at (LOL).
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,095
Office Version
365
Platform
Windows
Assuming that you just want month and year.
Formatting the cell would look like: myy
To use a formula to convert the value would be: =TEXT(A1,"myy")
 

Watch MrExcel Video

Forum statistics

Threads
1,096,305
Messages
5,449,563
Members
405,571
Latest member
Flux1234

This Week's Hot Topics

Top