DATE function start date 1/1/1900
The date 1/1/1900 is serial # 1 in Excel as though that was the first day in time. Hence, in dealing with immigration from the 1800s - 1900s (for example, the idiot known as Donald Trump and his Nazi/Communist kin, Microsoft Excel cannot delineate between 1911 and 1811. This goes well beyond the lack of apparent disinterest in providing similar levels of customer service, or product or brand experience. This is about charging the same price for a vastly inferior product. More often than not, functions beyond simple 10-key and numerical operators are discovered to be 'undoable on a Mac. It seems a good place to start would be to a) identify the many features one cannot perform on a Mac that child's play on a PC - simply own those; 2) make use of practical examples with real world examples and supporting documentation. Because the help menu is abysmal. Look at the example attached. Most do not work. Is this due to a mac formatting issue?
That reminds me: the "evaluate formula" feature (function key + F9) is ESSENTIAL. Not having that feature further relegates Office/Excel for Mac a dinosaur to all but extreme power users - because they can possibly look at the function and identify the errors. Others cannot.
BIRTH DATE = Date(Year(A1)-Age(Years[B1]), month(A1),Day(A1)
So if column A is "Date of Immigration to US", column B is "Age" and column C is "Birth date" of "May 17, 1901" at the age of "16" I guess might look like this:
Row1: Date Immigrated to US Age at Immigration Date of birth
05/17/01 16 05/17/85
should yield the correct date 05/17/85 (notwithstanding the fact Excel thinks it is 1985 - because nothing in the world happened until the year 1900, LOL
so presumably Birthdate" -
No Sunburst Charts or other Nov.