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

[minhhieule89]

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]

What leads you to believe it's the 23rd of June?

What date would 18175 be?

 

[wideboydixon]

Add 25100 to it? Tricky to see a pattern with only one example.

WBD

 

[minhhieule89]

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]

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]

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))

 

[wideboydixon]

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]

Well, I know it's got a 'y' in it...

 

[minhhieule89]

Well, I know it's got a 'y' in it...

thanks a ton, would adding 25100 always work as well? just curious

 

[RoryA]

Not unless all your dates are in 2018.