Julie - Good video. Some excellent examples of different timeline charts. If you are using Excel for timelines in genealogy work, you may encounter problems with very old dates. Excel's date values are predicated on a starting date back in 1904. Dates entered prior to that may be problematic. The simple solution is to have a column for each of month, day, and year.
Yes, Excel is a pain when it comes to dates pre-1900. That's why I use the YYYY-MM-DD custom format so that I can still sort and not have to have 3 different columns.
You can just set it to text or general? That's what I do, but, then again, I've never had this issue with Excel. I use old dates all the time. DD-MM-YYYY
This was very helpful in showing how the different timelines allow you to answer different questions, and garner thoughts about additional questions.
Julie - Good video. Some excellent examples of different timeline charts.
If you are using Excel for timelines in genealogy work, you may encounter problems with very old dates. Excel's date values are predicated on a starting date back in 1904. Dates entered prior to that may be problematic. The simple solution is to have a column for each of month, day, and year.
Yes, Excel is a pain when it comes to dates pre-1900. That's why I use the YYYY-MM-DD custom format so that I can still sort and not have to have 3 different columns.
You can just set it to text or general? That's what I do, but, then again, I've never had this issue with Excel. I use old dates all the time. DD-MM-YYYY
If you add dates in different format, you can sort them in excel. Year, mon,day. I.e. 2023.03.25