Shampoo and cookies get an AI makeover as consumer giants rewire their labs


The AI story has mostly been told through chips, data centres, and the companies building the models. It is now being told through the shampoo aisle.

The world’s largest makers of everyday goods, the businesses behind the bottles and packets in most kitchens and bathrooms, say they are using artificial intelligence to design products and run the campaigns that sell them, turning a technology associated with software into a fixture of the consumer-goods lab.

It is the same wave of enterprise adoption that has pulled AI tooling into corporate software stacks, arriving now in categories as unglamorous as body wash and biscuits.

Procter & Gamble offers the clearest example of what this looks like inside research and development.

The 💜 of EU tech

The latest rumblings from the EU tech scene, a story from our wise ol’ founder Boris, and some questionable AI art. It’s free, every week, in your inbox. Sign up now!

The company says it used AI to screen tens of thousands of peptides in developing a formula for a Pantene product, drawing on an internal database of more than 8,500 formulations to predict how a mixture would feel on skin or hair before anyone mixed it.

The point is not novelty for its own sake. It is time. Steps that once required rounds of physical testing can be narrowed down computationally, which pushes candidates toward consumer trials faster.

Mondelez, the snacking company behind a long list of familiar biscuit and chocolate brands, describes a similar shift on the food side.

It says an AI product-development tool has helped it generate dozens of new formulations, and that the software lets developers move between two and five times faster than conventional methods.

The same generative systems are being pointed at marketing, producing personalised images, text, and video at a pace traditional studios cannot match.

Unilever has leaned hardest into the campaign side. Its Dove brand ran a cookie-scented body-care line in partnership with Crumbl, with AI involved across the effort, from product direction to the selection of influencers and the creative itself.

The company reported the campaign drew billions of impressions and brought a large share of new buyers to the brand. Whatever one makes of a cookie-scented soap, the mechanics are instructive: a single AI-assisted pipeline running from formulation to feed.

What ties the examples together is compression. In consumer goods, the traditional cost of experimentation is measured in months of lab work and test batches, and the traditional cost of a campaign is measured in agency hours. AI attacks both.

Reformulation becomes a search problem over known ingredients, and content becomes something generated and varied on demand, an approach that mirrors the advertising ambitions on display when OpenAI pitched AI-made ads at Cannes.

The claims deserve some caution. Most of the specific figures come from the companies themselves, and consumer giants have every reason to present their AI programmes as further along than they are.

Product development still ends with human tasting panels and dermatological testing, and a formula an algorithm likes is not the same as one a shopper buys twice.

The industry’s own researchers have flagged that AI-generated marketing often drifts toward the generic, missing the brand-specific character that makes a campaign land.

Still, the direction is consistent across firms that rarely agree on much. The reallocation of enterprise budgets toward AI agents and tooling has become a general feature of large companies, from Tencent’s enterprise agents to the consumer-goods R&D described here, and the packaged-goods sector is not sitting it out.

For shoppers, the visible result will be mundane: more variants, faster refreshes, scents and textures that arrive and vanish more quickly than they used to.

The machinery behind the shelf is changing even where the products look the same. A bottle of shampoo is, increasingly, the output of a search.



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