The Chocolate Cake Guy
New Member
- Joined
- Oct 8, 2020
- Messages
- 5
- Office Version
- 2013
- Platform
- Windows
- MacOS
Does anyone have a formula to drag down an EXCEL column "Sunday, January 1, 1900" in descending order? As most know, one cannot format cells with "Number" "Date Category" prior to 1900. I am trying to list pre 1900 dates in a column in descending order like the following:
Monday, January 2, 1900
Sunday, January 1, 1900
Saturday, December 31, 1899
Friday, December 30, 1899
Thursday, December 29, 1899
Thanks in advance for any help on the matter,
Cake Guy
Monday, January 2, 1900
Sunday, January 1, 1900
Saturday, December 31, 1899
Friday, December 30, 1899
Thursday, December 29, 1899
Thanks in advance for any help on the matter,
Cake Guy