Sort by date with empty rows (dates of 1/1/1900) on the bottom

%3CLINGO-SUB%20id%3D%22lingo-sub-2174521%22%20slang%3D%22en-US%22%3ESort%20by%20date%20with%20empty%20rows%20(dates%20of%201%2F1%2F1900)%20on%20the%20bottom%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174521%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%20I%20have%20a%20%22Master%22%20sheet%20that%20is%20pulling%20information%20in%20from%207%20other%20sheets%20in%20the%20same%20workbook%20(these%20are%20courses%20being%20offered%2C%20so%20the%20%22Master%22%20should%20have%20the%20entire%20schedule).%20The%207%20other%20sheets%20are%20of%20varying%20length%3B%20each%20program%20manager%20offers%20an%20unknown%20number%20of%20workshops%20each%20semester%2C%20so%20one%20tab%20might%20have%2020%20entries%20while%20others%20might%20have%2050%2C%20etc.%20I'd%20like%20to%20be%20able%20to%20sort%20the%20Master%20sheet%20by%20date%2C%20but%20have%20all%20rows%20with%20empty%20dates%20(which%20Excel%20thinks%20are%201%2F1%2F1900)%20either%20hidden%20or%20showing%20up%20after%20all%20of%20the%20others.%20Is%20this%20possible%3F%20And%20is%20it%20better%20to%20do%20this%20with%20a%20macro%3F%20I'd%20like%20to%20avoid%20the%20Macro%20if%20possible%20since%20the%20workbook%20will%20largely%20be%20edited%20in%20Teams%2C%20but%20the%20nerd%20in%20me%20kind%20of%20wants%20to%20learn%20more%20VB.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2174521%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello - I have a "Master" sheet that is pulling information in from 7 other sheets in the same workbook (these are workshops being offered, so the "Master" should have the entire schedule). The 7 other sheets are of varying length; each program manager offers an unknown number of workshops each semester, so one tab might have 20 entries while others might have 50, etc. I'd like to be able to sort the Master sheet by date, but have all rows with empty dates (which Excel thinks are 1/1/1900) either hidden or showing up after all of the others. Is this possible? And is it better to do this with a macro? I'd like to avoid the Macro if possible since the workbook will largely be edited in Teams, but the nerd in me kind of wants to learn more VB. 

1 Reply

@physnicks Not sure what you are trying to achieve here, but perhaps a formula like below is what you need in H3.

=IF(ISBLANK(JW!H3),"",JW!H3)