Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I managed to import numbers from excel using the following formula B1 "=DATE(1900;1;−1)+A1"
The other suggested one in several forums (DATE(1904,1,1)+1 won't work for me, first because the , must be a ; and second because of the numbers that for some strange reason I needed to change. now it works.
Mac mini, macOS 11.4
I’m didn’t spend time on the forum with a theory, I just wanted to help people that like me may be searching for a solution. Whether there’s a typo or whatever I don’t know, what I do know is that the formula I posted works on my numbers 11.something. With the comma didn’t work then I tried with the semicolon and now it works. Same for the -1
I’m didn’t spend time on the forum with a theory, I just wanted to help people that like me may be searching for a solution. Whether there’s a typo or whatever I don’t know, what I do know is that the formula I posted works on my numbers 11.something. With the comma didn’t work then I tried with the semicolon and now it works. Same for the -1
Excel has two different date systems. One starts in 1900, the other in 1904. That is why the number is different.
I believe neither of those formulas is correct. The second one has a few typos but the first one is just not right.
Using a -1 in the DATE function will give you a warning triangle. It works but -1 is an out of range value.
In Excel's 1900 date system, 1/1/1900 is day 1. Excel also coded in a nonexistent leap year in 1900. Both have to be taken into consideration. The correct formula for dates starting in March 1900 is
=DATE(1900;1;1)-2+A1
Some regions use a semicolon vs a comma to separate parameters in functions. If you use a comma (not decimal point) as a decimal separator you will use a semicolon in functions.
There have been an awful lot of Excel date questions/post lately. I wonder if a recent release broke the conversion of Excel dates more than it already was.
Import Dates from Excel to Numbers
