Formula Errors

How to Fix an Excel Formula to Concatenate Cells When a Date Is Today

Muhammad TalhaMuhammad Talha Nov 13, 2026 870 views

Question details

The user needs to correct an IF formula so it concatenates values from C2, D2, E2, and F2 only when the date in A2 matches today’s date.

How to Fix an Excel Formula to Concatenate Cells When a Date Is Today
Product
WPS Office Spreadsheet
Device & OS
not provided
Scenario
The user is working in a spreadsheet with dates in column A and values in columns C through F, and wants a single cell to show the combined text only for today's date.
Observed behavior
The current formula returns literal text such as C2&D2&E2&F2, FALSE, or 0 instead of the concatenated cell values.
Before you start

Confirm that column A contains real date values rather than text, and check whether your WPS Office Spreadsheet uses commas or semicolons as formula argument separators.

Solution 1Recommended

Correct the IF Formula with TODAY and Concatenation Operators

Use this formula when the date in A2 is stored as an actual date and you want a blank result for non-matching dates.

Excel and WPS Office Spreadsheet evaluate A2=TODAY() as a logical test. If the test is true, the ampersand operators join the text from C2, D2, E2, and F2; if false, the formula returns an empty string instead of FALSE or 0.

1
Select the result cell

Click the cell where you want the concatenated result to appear, such as G2.

2
Enter the corrected formula

Type =IF(A2=TODAY(),C2&D2&E2&F2,"") in the formula bar. Do not put quotation marks around C2, D2, E2, or F2.

3
Press Enter and verify

Press Enter. If the date in A2 is today, the cell shows the combined text; if not, it stays blank.

4
Apply to additional rows

Drag the fill handle down from the result cell to copy the formula to the rows that need the same date check.

Correct the IF Formula with TODAY and Concatenation Operators
Formula fixed: The result now returns concatenated values only when A2 equals today’s date, and returns an empty string otherwise.

Correct the Concatenate Formula in WPS Office Spreadsheet

Open the same workbook in WPS Office Spreadsheet and use the Excel-compatible IF and TODAY functions to return concatenated cell values only for today’s date. WPS Office preserves formulas, cell references, and .xlsx formatting so you can fix the file without changing tools.

  1. 1. Open the workbook in WPS Office: Launch WPS Office Spreadsheet and open the .xlsx file containing the broken formula.
  2. 2. Select the result cell: Click the cell where you need the corrected concatenation formula, such as G2.
  3. 3. Enter the formula: Type =IF(A2=TODAY(),C2&D2&E2&F2,"") into the formula bar.
  4. 4. Press Enter and test: Press Enter, then verify that only today’s date row returns the combined text.
  5. 5. Save the file: Save or save as .xlsx to keep the corrected formula and Excel compatibility.
WPS Office Spreadsheet is fully compatible with Excel IF, TODAY, and concatenation formulas.Opens, edits, and saves .xlsx workbooks without losing formulas or layout.Free, lightweight spreadsheet editor with a familiar ribbon interface.Lets you fix and test date-based formulas without a Microsoft 365 subscription.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my formula show the text C2&D2&E2&F2 instead of the cell values?

Because the cell references are enclosed in quotation marks. Remove the quotes so WPS Office treats them as references: =IF(A2=TODAY(),C2&D2&E2&F2,"").

What should I do if the date in A2 also contains a time?

Use =IF(INT(A2)=TODAY(),C2&D2&E2&F2,"") to ignore the time and compare only the date part. The formula =IF(A2>=TODAY(),C2&D2&E2&F2,"") also matches dates today or later, so choose it only if that behavior is intended.

Does this formula work in WPS Office Spreadsheet?

Yes. WPS Office Spreadsheet supports the same IF, TODAY, and ampersand concatenation operators as Excel, so the formula can be used in .xlsx or WPS workbooks.

How do I know if my formula uses commas or semicolons?

Most WPS Office Spreadsheet versions accept commas as argument separators. If the formula returns an error, replace the commas with semicolons: =IF(A2=TODAY();C2&D2&E2&F2;"").

Why does my formula return 0 or FALSE?

If the value_if_false argument is missing or the cell references are quoted incorrectly, the formula can return FALSE or 0. Add an empty string as the false result and remove quotes from cell references to get a blank cell.