How to Add a Date to an Excel Label with TEXT

Open an Excel workbook (.xlsx) in Cue Office. Use TEXT to format a date, then use & to attach it to the label prefix. Put the formula in a separate column so you can copy the labels and still use the original dates in calculations.

How do you create a label like Inventory | 2027-06-08?

Open the community supply inventory sheet. Column B, Stocktake date, tracks stocktake dates, and Column C, Inventory label, is reserved for labels. Cell B2 for Pantry boxes shows 6/8/2027, and the label received by the warehouse needs to be written as Inventory | 2027-06-08.

Four inventory batches with three dates in the Stocktake date column and an empty Inventory label column
The starting sheet has three stocktake dates, while the date for Hygiene packs is not yet filled in.

Enter C2 in the name box and press Enter. Copy the four formulas below and paste them into C2. They fill C2:C5 in order, each using the date from column B on the same row.

=IF(B2="","","Inventory | "&TEXT(B2,"yyyy-mm-dd"))
=IF(B3="","","Inventory | "&TEXT(B3,"yyyy-mm-dd"))
=IF(B4="","","Inventory | "&TEXT(B4,"yyyy-mm-dd"))
=IF(B5="","","Inventory | "&TEXT(B5,"yyyy-mm-dd"))

TEXT(B2,"yyyy-mm-dd") formats the year, month, and day into four digits, two digits, and two digits respectively. & concatenates this formatted date string after the prefix. B2 continues to display 6/8/2027, while C2 in the same row displays Inventory | 2027-06-08.

C2:C5 selected with IF and TEXT shown in the formula bar and three visible labels
Four rows of formulas generate three labels. Rows without a stocktake date remain blank.

What happens if a source date is blank or changed later?

The Hygiene packs batch has no date in B4. The outer IF checks for an empty source and displays a blank label in C4. Its formula stays in place and can generate a label when you enter a date.

Use File → Save As… to save the manual version first. To verify the link, temporarily change B2 to =DATE(2027,6,9) in the copy. C2 will update to Inventory | 2027-06-09.

B2 temporarily changed to June 9, 2027, with the C2 label updating accordingly
Temporarily change B2 to June 9, and the label in C2 updates automatically.

Undo the test edit, then close and reopen the saved copy. Verify that B2 is still 6/8/2027, C2 displays Inventory | 2027-06-08, and C4 remains blank. Select C2 to check the formula bar.

Reopened manual file showing the B2 date along with the original C2 label and formula
The original dates and labels are visible after reopening the manual copy.

How do you ask Cue AI to fill only the label column?

Open a copy of the inventory sheet where the label column has not been filled in yet, and click Cue AI on the toolbar. In the prompt, specify the output range, date format, and how to handle blank dates.

Cue AI toolbar button and the open pane on the left
Open Cue AI in a copy of the inventory sheet.
Create copy-ready inventory labels in C2:C5 using the stocktake dates in B2:B5. For each date, write Inventory | followed by the date as four-digit year, two-digit month, and two-digit day separated by hyphens. If the source date is blank, show an empty label. Keep the labels linked to the dates so edits update them. Change only C2:C5 and leave the source dates and their formatting intact.

After the changes are applied, use File → Save As… to save an AI copy. Temporarily change B2 to =DATE(2027,6,10) to confirm that C2 updates to Inventory | 2027-06-10.

B2 in the AI copy temporarily changed to June 10, updating the label to Inventory | 2027-06-10
Labels generated by AI also update when the date in B2 changes.

Discard this test edit upon closing, then open the saved AI copy from disk. Check the source dates in Column B and the three labels in Column C. When you select blank cell C4, the formula bar still shows the formula for that cell.

C4 appears blank after reopening the AI copy, with IF and TEXT still in the formula bar
After reopening the AI copy, C4 still looks blank and its formula is visible in the formula bar.

Practice with four supply batches

Show the full example

Set up the example in A1:C5. The dates shown use month/day/year. Enter them in a format your workbook recognizes. Leave B4 empty and reserve C2:C5 for the formulas. Return to the label formulas.

Batch	Stocktake date	Inventory label
Pantry boxes	6/8/2027
First-aid kits	6/17/2027
Hygiene packs	
Winter blankets	12/3/2027

Verify pending batches before handing off labels

For the next stocktake, ask Cue AI to generate the same labels from the updated dates. Before sending the labels to the warehouse, check the dates for the first-aid kits and winter blankets. Leave the hygiene packs on the list of batches to verify until someone enters their stocktake date.

Record the stocktake dates in the Excel inventory sheet (.xlsx) in Cue Office and list any batches still to verify in the Word handover (.docx). Use the storage map (.pdf) to locate those batches, then assign each count in the PowerPoint shift briefing (.pptx). Spreadsheets, documents, and presentations are free to edit, and PDFs are free to read.

Download Cue Office for free