# Date formula

Solved/Closed
Related:

- Date formula
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide

## 7 responses

Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147

Aug 7, 2015 at 02:12 PM

Aug 7, 2015 at 02:12 PM

**Judy**, Good afternoon.

Suppose A1 = 152030355A

Try to use:

**=DATE(LEFT(A1,2),MONTH(MID(A1,3,3)),DAY(MID(A1,3,3)))**

Is that what you're looking for?

I hope it helps.

--

Belo Horizonte,

**Brasil**.

Marcílio Lobão

Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147

Aug 7, 2015 at 03:17 PM

Aug 7, 2015 at 03:17 PM

HI.

Sorry, I forgot about the 20 at the year. hi hi hi

This formula works for all the julian calendar.

The layout of your data must be the same all the time, off course.

Please, give us some example where the formula don't works well to easier our help to you.

Sorry, I forgot about the 20 at the year. hi hi hi

This formula works for all the julian calendar.

The layout of your data must be the same all the time, off course.

Please, give us some example where the formula don't works well to easier our help to you.

Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147

Aug 7, 2015 at 06:50 PM

Aug 7, 2015 at 06:50 PM

Ok.

I read your formula.

There is a mistake on it.

Please, pay attention at a DAY part of it.

My suggestion:... DAY(MID(A1,3,3))

Your Formula:..... DAY(MID(A1,3,

Correct the formula and try again.

I hope it will work after it.

--

Belo Horizonte,

Marcílio Lobão

I read your formula.

There is a mistake on it.

Please, pay attention at a DAY part of it.

My suggestion:... DAY(MID(A1,3,3))

Your Formula:..... DAY(MID(A1,3,

**4**))Correct the formula and try again.

I hope it will work after it.

--

Belo Horizonte,

**Brasil**.Marcílio Lobão

Didn't find the answer you are looking for?

Ask a question
Hi,

I tried the formula starting at the beginning of the year and it works until I get to 3/2/2015 or 1506100355A and I get 3/1/2015 again.

Can you think of a way to resolve the problem?

Thanks for your help.

I tried the formula starting at the beginning of the year and it works until I get to 3/2/2015 or 1506100355A and I get 3/1/2015 again.

Can you think of a way to resolve the problem?

Thanks for your help.

Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147

Aug 12, 2015 at 08:43 AM

Aug 12, 2015 at 08:43 AM

**Judy**, Good morning.

Try to use this new suggestion:

**=DATE(20&LEFT(A1,2),MONTH(1),DAY(1))+(MID(A1,3,3))-1**

Please, tell us if it worked for you this time.

I hope it helps.

--

Belo Horizonte,

**Brasil**.

Marcílio Lobão

Aug 7, 2015 at 02:47 PM

I changed the formula to =DATE(20&LEFT(A1,2),MONTH(MID(A1,3,3)),DAY(MID(A1,3,4))) and this worked for only one date 7/22/2015, but I need it for all of the dates in the Julian calendar. If you can figure out anything that works I would appreciate it. I will try on my end, also.

Thank you very much for your help.