I am not what you would call an audiophile. I don’t obsess over terms like LDAC and DSEE upscaling. For me, they’re just another utilitarian gadget to get the job done. Somewhere along the way, however, I stopped judging earbuds purely on how they sound and started paying closer attention to how naturally they fit into an ordinary day.
So much of this category now chases bass, noise cancellation, and a spec sheet full of features that comfort has quietly become an afterthought. I recently got a chance to try the Baseus Bowie MC2, my first pair of earclip-style earbuds. It came as a revelation for me. I picked them up from Amazon at $40, so it wasn’t a big hit on my wallet either. The leap of faith, I’d say, was well worth it.
Comfort, above all
Krittika Owary / Digital Trends
After several days of living with these earbuds through my normal routine, that’s exactly what stood out. It wasn’t a single feature, but how effortless they were to simply wear. I’ve spent plenty of time with wireless in-ears, so this isn’t new territory for me. Even so, these set themselves apart almost immediately through sheer weightlessness.
The first time I properly settled in with them, I wore them from around 8 PM until nearly 12:30 AM without a break, and my ears never once felt sore or irritated. That’s rare. Most earbuds start announcing themselves after a couple of hours, thanks in no part to a growing pressure, and a low-level discomfort you can’t quite ignore. Here, that sensation barely registered.
Krittika Owary / Digital Trends
After a while, I genuinely forgot I had them in. They sit so lightly that the usual awareness of something lodged in your ears simply fades. Even after a five-hour stretch of continuous use, they stayed comfortable, and comfort over that kind of duration is not something I hand out easily to in-ear designs.
I also came to appreciate that they don’t seal you off from the world. Total isolation has its place, but for everyday use, I preferred staying tethered to my surroundings. Walking around the house, working through chores, or just listening late at night, I never felt fully cut off. That makes for a far more relaxed experience than the hermetic, plugged-up feeling a lot of sealed earbuds impose.
It feels more natural
Krittika Owary / Digital Trends
Another subtle touch won me over, too. The way the audio starts. Rather than slamming sound into your ears the instant playback begins, it eases in. It sounds like a trivial detail, but over long sessions it adds up to something noticeably less harsh and less fatiguing. Battery life has been quietly excellent throughout. On the first day, after roughly four and a half hours of listening, the buds were still showing 90 percent of juice left in the tank.
What impressed me more was the drain over time: it took days of regular use before the charge finally slipped to around 40 percent, which makes them refreshingly low-maintenance to fold into daily life. Fit and stability have been mostly dependable. They hold firm through brisk walks and general outdoor use, though I wouldn’t stake my confidence on them under a motorcycle helmet.
Krittika Owary / Digital Trends
I did catch the right bud working loose now and then, depending on how I moved, so the security of the fit will vary a little from one ear to the next. Call quality has held up well, too. Even at ordinary volume, voices come through naturally and easily, with none of the constant volume-nudging that lesser earbuds demand.
Taken together, these don’t feel like a flashy piece of tech straining to impress. They slip into your routine and stay out of the way. That invisible existence, more than anything, is why they won me over. Their real strength isn’t a single headline feature, but how effortlessly they disappear over long stretches, never once nagging you that they’re there.
Microsoft Excel handles temporal data effectively if you know which formulas to use. The problem is that Excel includes over 20 date and time functions, but most people only ever need a small core set to build powerful, self-updating workflows. These essential date functions turn messy timelines into automated systems you can actually rely on.
All examples in this guide use an Excel table (Ctrl+T) named ProjectTracker (pictured below). To follow along, download a free copy of the Excel workbook containing this table. After you click the link, you’ll find the download button in the top-right corner of your screen.
Excel views your calendar as a massive string of numbers
The secret logic behind spreadsheet dates
Excel stores dates as serial numbers—starting at January 1, 1900—and displays them using date formats. For example, June 1, 2026 is stored internally as 46174. This allows you to perform arithmetic on dates, such as adding 7 to move forward one week.
Excel intentionally treats 1900 as a leap year for compatibility with older spreadsheet systems. This is not historically accurate, but it rarely affects modern workflows unless you’re working with very old date ranges.
Keep your timelines moving with real-time tracking
Creating a live project countdown with TODAY
If you currently update a “Today” cell manually each morning to keep deadlines accurate, Excel can replace that workflow with a dynamic function that always returns the current date.
To create a live countdown that updates automatically as time passes, add a new column with the following name, formula, and formatting:
Column Name
Days Remaining
Formula
=[@[Due Date]]-TODAY()
Number Format
General
When you press Enter, Excel may automatically format the result as a date instead of a number. That’s why you must select the table column and set the format to General in the Number group of the Home tab.
Each task displays the number of days remaining until its due date, with negative values indicating tasks that are already overdue.
The next time you open the workbook, the calculations will refresh and automatically update based on the new day.
Isolate specific time frames by breaking dates into pieces
Structuring reports with MONTH, YEAR, and WEEKDAY
When working with project schedules, full date values like 2026-07-24 are often too detailed for analysis. You may need to group tasks by month, summarize yearly progress, or identify scheduling issues like weekend start dates.
To extract the month, delete the Days Remaining column, then add a new one with these parameters:
Column Name
Month Due
Formula
=MONTH([@[Due Date]])
Number Format
General
Each task returns a numeric month value, such as 6 for June or 7 for July, making it easier to filter and group tasks by month.
To isolate the year for reporting across longer timelines, simply replace MONTH in the formula above with YEAR:
Column Name
Year Due
Formula
=YEAR([@[Due Date]])
Number Format
General
To identify scheduling issues, such as tasks that begin on weekends, you need a different approach because weekdays are not stored as simple calendar parts like month or year. Instead, Excel assigns each weekday a numeric position based on a selected system.
Here’s what to do in a new column:
Column Name
Weekday Due
Formula
=WEEKDAY([@[Start Date]], 2)
Number Format
General
With the 2 argument, Excel treats Monday as day 1 and Sunday as day 7. Without this argument, Excel uses its default system where Sunday is treated as day 1 and Saturday as day 7.
Each task now returns a number from 1 to 7, where values 6 and 7 correspond to Saturday and Sunday, making weekend starts easy to identify.
OS
Windows, macOS, iPhone, iPad, Android
Free trial
1 month
Microsoft 365 includes access to Office apps like Word, Excel, and PowerPoint on up to five devices, 1 TB of OneDrive storage, and more.
Calculate exact working durations without the weekend clutter
Using NETWORKDAYS to measure real work time
Calendar-based durations often overstate actual work time. A task running from Friday to Monday appears to take four days, even though only two are working days.
So, to calculate true working days between project milestones, add this column:
Column Name
Working Days
Formula
=NETWORKDAYS([@[Start Date]], [@[Due Date]])
Number Format
General
Excel returns the total number of working days between the start and due dates, counting both endpoints when they fall on working days.
To include holidays, create a separate range containing vacation dates (for example, starting in cell F2). Then, select the first Working Days formula cell, and extend the formula to:
Using absolute references ($) ensures the holiday range does not shift when the formula is filled down the table.
When you press Enter, you’ll see that the calculation now excludes both weekends and holidays.
If your workweek is non-standard, use NETWORKDAYS.INTL to define custom weekend rules.
Map future deadlines and end-of-month cutoffs
Using WORKDAY and EOMONTH for automated scheduling
Beyond tracking existing timelines, Excel can generate future dates based on rules such as working durations and billing cycles.
To calculate a projected completion date based on working days, remove the Due Date column, then add these two columns.
Column 1:
Column Name
Expected Duration
Values
Manually enter the number of working days.
Number Format
General
Column 2:
Column Name
Projected Finish
Formula
=WORKDAY([@[Start Date]], [@[Expected Duration]])
Number Format
Date
Excel returns a date representing the expected completion based on the specified number of working days. It automatically skips weekends and returns the next valid working date.
To calculate billing cutoffs that always land on month-end, use this workflow:
Column Name
Billing Cutoff
Formula
=EOMONTH([@[Start Date]], 0)
Number Format
Date
Excel returns the last day of the month for each task, making billing cycles consistent.
Planning ahead with month-based review dates
Shifting dates across months with EDATE
Not all scheduling problems are about counting days. In real project work, you often work in monthly cycles—such as scheduled reviews, audits, or check-ins that repeat at predictable intervals.
For example, if a project phase starts on a given date, and you need to schedule a formal review three months later, Excel has a built-in function designed exactly for this. EDATE shifts a date by a specified number of months while preserving the day of the month when possible.
Here’s how to use it:
Column Name
Review Date
Formula
=EDATE([@[Start Date]], 3)
Number Format
Date
This moves the start date forward by three full months. For example, if the start date is June 1, 2026, Excel returns September 1, 2026.
You can also move backward in time when planning earlier review checkpoints, such as retrospective checks or pre-launch assessments. In those cases, you use a negative value:
=EDATE([@[Start Date]], -2)
Unlike day-based subtraction, EDATE respects calendar structure, making it more reliable than manually shifting dates.
Take control of your spreadsheet timelines
Ignoring Excel’s built-in date tools often leads to hours of manual updates and fragile spreadsheets. By understanding how Excel stores dates and using functions designed to work with them, you can build schedules that update themselves and forecast future milestones automatically. Once you’ve mastered tracking time with formulas, the next step is visualizing it—turn your data into a dynamic timeline that updates as your project evolves.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.