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.
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.
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.
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.
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.
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.
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.
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.