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?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
What leads you to believe it's the 23rd of June?

What date would 18175 be?
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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:
Upvote 0
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
 
Upvote 0
Well, I know it's got a 'y' in it... ;)
 
Upvote 0
Not unless all your dates are in 2018.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top