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

minhhieule89

Board Regular
Joined
Jul 16, 2014
Messages
68
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
Joined
Dec 21, 2009
Messages
3,376
What leads you to believe it's the 23rd of June?

What date would 18175 be?
 

minhhieule89

Board Regular
Joined
Jul 16, 2014
Messages
68
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
Joined
Dec 21, 2009
Messages
3,376
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
Joined
May 2, 2008
Messages
34,615
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
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
Joined
Jun 2, 2016
Messages
3,401
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
Joined
May 2, 2008
Messages
34,615
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Well, I know it's got a 'y' in it... ;)
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,615
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Not unless all your dates are in 2018.
 

Forum statistics

Threads
1,086,057
Messages
5,387,553
Members
402,071
Latest member
hyperf0

Some videos you may like

This Week's Hot Topics

Top