Excel date system

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 ?



3 Replies



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


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




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


Very thanks 


By the way, you may simplify your formula using

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