# How to convert this number 18174 to June 23, 2018 in Excel?

#### minhhieule89

##### Board Regular
I just received a report in which has this number 18174, I know for sure it equals to June 23, 2018 but Excel date value is 43274

is there a way to convert that 18174 to the right date format in Excel?

#### Comfy

##### Well-known Member
What leads you to believe it's the 23rd of June?

What date would 18175 be?

#### wideboydixon

##### Well-known Member
Add 25100 to it? Tricky to see a pattern with only one example.

WBD

#### minhhieule89

##### Board Regular
because that is the due date, I also know 18176 is June 25, 2018, looks like adding 25100 would work, but there must be a reason

#### Comfy

##### Well-known Member
Because dates in excel are actually a count of days since 00/01/1900.

So to get from 18176 days after this date to 43274 days you can just add 25100

#### RoryA

##### MrExcel MVP, Moderator
23rd June 2018 is the 174th day of 2018, hence 18174, I would guess. So, if that is in A1:

=DATE(LEFT(A1,2)+2000,1,RIGHT(A1,3))

Last edited:

#### wideboydixon

##### Well-known Member
23rd June 2018 is the 174th day of 2018, hence 18174, I would guess. So, if that is in A1:

=DATE(LEFT(A1,2)+2000,1,RIGHT(A1,3))
Amazing! Can you do that thing where you work out what day of the week someone was born on given their DOB?

WBD

#### RoryA

##### MrExcel MVP, Moderator
Well, I know it's got a 'y' in it...

#### minhhieule89

##### Board Regular
Well, I know it's got a 'y' in it...
thanks a ton, would adding 25100 always work as well? just curious

#### RoryA

##### MrExcel MVP, Moderator
Not unless all your dates are in 2018.