I brought a Bose, Sony, and JBL speaker to the beach – this one’s my new outdoor essential


Bose SoundLink Plus in Citrus Yellow

Jada Jones/ZDNET

Follow ZDNET: Add us as a preferred source on Google.


As a Georgian, it’s customary to travel down to Florida to get some sun on the beach during summer vacation. I figured this year, I’d take a few of the latest Bluetooth speakers with me to better gauge their performance.

Also: I flew 2,700 miles with Apple, Sony, and Sennheiser headphones – this pair had the best audio

As with the many headphones I test, it’s easy to form a positive opinion of a speaker in controlled environments such as my home office, front porch, or parents’ backyard. But throw that same speaker into some uneven loose sand, uncontrollable ocean waves, and a nearby naval base and you have some totally different conditions. 

I took the Bose SoundLink Plus, JBL Charge 6, and Sonos Play, outside with me while I relaxed on the shores of Pensacola Beach, using a different speaker each day. Here’s how it went.

Day 1: JBL Charge 6

JBL Charge 6 in Purple

Jada Jones/ZDNET

The good: portability, Auracast

The Charge 6 lies horizontally, and its carrying strap clips one end to the other. Thus, you get a comfortable handle that makes it easy to carry the three-pound speaker. Since JBL supplied the Charge 6 with Auracast, if you have a compatible smartphone, you can play music from one phone to several Auracast-enabled speakers, regardless of manufacturer. 

Review: JBL Charge 6

JBL’s implementation of Auracast is a huge plus, considering Bose doesn’t support the feature, instead forcing you to purchase another one (keyword, one) of its speakers for Party Mode, while Sonos supports grouping with up to four speakers, but limits this feature to the Move 2 and Play speakers.

The bad: battery

The JBL Charge 6 has the longest advertised battery life out of this trio, promising 24 hours of playtime plus an additional four hours with the Playtime Boost battery-saving feature enabled. Though 28 hours is impressive, Playtime Boost significantly dampens the speaker’s bass response, which is no good when noisy waves, children, and military jets are in the equation.

In a noisy environment, like a public beach in the middle of June, the Charge 6 won’t offer 24 hours of playtime, let alone 28. To combat environmental noise, I increased the speaker’s volume, which consumes more power and shortens your playtime – very common for portable speakers as a whole, not just JBL.

Also: 48 hours later with the Google Home Speaker, I can’t stop talking to Gemini (even if it’s imperfect)

I used about 45% of the battery over six hours, so I probably could have squeezed out nearly seven more. I didn’t need to use the Charge 6’s reverse USB-C charging to charge my phone, but if I did, it would also drain the speaker’s battery quicker.

Day 2: Bose SoundLink Plus

Bose SoundLink Plus in Citrus Yellow

Jada Jones/ZDNET

The good: style, bass, battery

Bose’s SoundLink Plus is a very stylish portable speaker. Its design is sleeker and more minimalist than JBL’s Charge 6, and it comes in more fun colors than Sonos’s Play. Anytime I’ve taken the SoundLink Plus out and about with other people, I always get compliments on its look. If you want a portable speaker that looks as good as it sounds, Bose has you covered.

Review: Bose SoundLink Plus

The SoundLink Plus’s strong bass is its greatest asset, as increasing the volume and tweaking the highs and mids in the Bose app brought vocals forward, while maintaining its strong bass response. I used the SoundLink Plus for nearly six hours, played it loudly, and had just under 70% battery left, which is on par with Bose’s advertised 20 hours. 

The bad: also the bass

Bose fitted the SoundLink Plus with a tweeter, a midwoofer, and four passive radiators. With this speaker configuration, the passive radiators work overtime to deliver a beefed-up bass response. However, with waves constantly crashing and the occasional fighter jet flying over me, at a lower volume, all I could hear was bass, as it cuts through the noise the most. 

Day 3: Sonos Play

Sonos Play

Jada Jones/ZDNET

The good: sound, voice assistant, auto EQ

The Sonos Play is a great-sounding speaker, fitted with three Class-H amplifiers that power two tweeters and one midwoofer for the brand’s signature smooth, fun sound. The Sonos Play features Automatic Trueplay, which uses the speaker’s built-in microphone to optimize its sound for your environment. This feature did help with balancing the Play’s sound, and it is available over Bluetooth. 

Review: Sonos Play

Sonos Voice Control also works over Bluetooth, though limited to basic controls, such as track play, pause, skip, and volume up/down. Still, I found this feature useful when I finally washed my hands of sand and didn’t want to touch the sandy speaker before eating.

The bad: design, battery

However, unlike the SoundLink Plus and Charge 6, the Play speaker sports a vertical orientation. It was difficult to keep the Play upright on the uneven sand, and laying it horizontally does alter the sound profile.

Also: Your Sonos smart speaker has an underutilized automation feature – 5 helpful ways I use mine

After a five-hour day, I used about half of the speaker’s battery, which means the Play could have offered me nearly 14 hours instead of its advertised 24. Again, it’s not uncommon for Bluetooth speakers’ playtime to run a little short when you’re using them outdoors and turning up the volume, which is directly related to their power consumption.

Writer’s choice

It’s tough to choose between the Bose SoundLink Plus and the JBL Charge 6 for outdoor adventures. Objectively, the SoundLink Plus better handled increased power demands, while the Charge 6 has a stronger durability rating and supports Auracast; both speakers support reverse USB-C charging.

Subjectively, I appreciated the SoundLink Plus’s stylish design and powerful bass response. For summer days outside, I’ll reach for it first.

Though the Sonos Play is a great speaker and offers many of the same features as Bose’s and JBL’s speakers, it loses much of its coveted features, such as voice assistant support and Wi-Fi streaming, as soon as you leave your home network. It’s much better suited for outdoor listening within your property line.

What about waterproofing?

The Bose SoundLink Plus and Sonos Play have an IP67 durability rating, while the JBL Charge 6 has an IP68 rating. All three speakers are waterproof and can withstand submersion in water up to three feet deep for up to 30 minutes, but the JBL charge can withstand submersion in water up to three-and-a-half feet for up to 30 minutes, making it the most durable of the bunch.

With their waterproof ratings, all three speakers can withstand splashes, droplets, jets, and brief, shallow submersion without significant damage. 

Also: I switched to a Bose-Sonos hybrid setup for my home audio – and it worked harmoniously

All three speakers are fully protected from solid objects, which translates to protection against sand, dust, dirt, or gravel in the real world. Based on these speakers’ durability ratings, all three responded well to sand exposure and were perfectly fine after a quick rinse with freshwater to remove any residual sand.

Ingress protection (IP) ratings, or durability ratings, are a focal point of Bluetooth speaker specs. These ratings determine how well a specific speaker withstands exposure to water and dust before these particles degrade its performance. The first number signifies solid particle resistance, while the second number indicates liquid resistance.

Manufacturers certify these speakers in controlled labs by blasting them with fine talcum powder and water from different directions at various pressures. 





Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


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.

A structured Excel tracking table containing project tasks, start dates, and due dates.

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

The numeric year component is successfully calculated for every row in the tracking table in Excel.

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.

The numeric weekday component is successfully calculated for every row in the tracking table in Excel.

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:

=NETWORKDAYS([@[Start Date]], [@[Due Date]], $F$2:$F$5)

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.



Source link