SOLVED
Home

Excel date system

Zorba4me
New Contributor

I have recently removed time from date by using the following function =DATE(YEAR(A7),MONTH(A7),DAY(A7)) then all date have been changed, why ? the date before apply function was 2019-01-01 17:32:45

the date after applying function have been converted to 1900-01-01

I wanted the date in the cell be just 2019-01-01

why this happen ? How can i solve this ?

 

thanks

3 Replies

Hello

 

If I try it I get 2019-01-01.

 

Change the number format of A7 to "General". What does show as a numeral value?

 

Hello

 

It's show "0". I solved it by adding new column and applying remove time function by choosing data from date cell : )

 

Very thanks 

Solution

By the way, you may simplify your formula using

=INT(A7)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies