•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I format dates in a specific order in a column?
I'm organizing dates in a table by the current date, then by past dates, and then by upcoming dates. For example, 02/04/2026,..., 01/31/2026,...,02/10/2026,.... The first entries would appear on the current date, followed by any dates before the current date (sorted from oldest to newest), and lastly by any upcoming dates (sorted from oldest to newest). It's to help organize assignments by due and past-due status. I also want any past dates to appear in bold red. What functions, formulas, and steps I would need to do?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#dates
#column
#current date
#past dates
#upcoming dates
#organizing
#table
#past-due status
#due
#entries
#bold red
#functions
#formulas
#steps
#sorting