From excel number to date

[Kamran1991]

Can anyone please let me know the process of converting below numbers into ?

44460

44461

44462

44463

44464

44465

They the numbers in excel converted from date of 21 Sep-26 Sep,2021

Your help will be highly appreciated!!!

[JosephSerpis]

Hi @Kamran1991 you just need to use a datetime add function to get these back into dates. You can read more from this post.

[Kamran1991]

Hi @JosephSerpis , thanks for your reply. Why is it 2 days ahead?

[JosephSerpis]

Check the post I highlighted in my previous reply as it expands on that more. 

[Qiu]

@Kamran1991 
As you said the DateTimeAdd seems to have some issue in this  case.

We can use ToDate to get the correct date for now.