Jan 15 2019 12:03 PM
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
Jan 15 2019 01:11 PM
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?
Jan 15 2019 03:31 PM
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
Jan 16 2019 02:16 AM
SolutionBy the way, you may simplify your formula using
=INT(A7)
Jan 16 2019 02:16 AM
Solution