How to Fix an Excel Formula to Concatenate Cells When a Date Is Today
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.

- 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.
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.
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.
Click the cell where you want the concatenated result to appear, such as G2.
Type =IF(A2=TODAY(),C2&D2&E2&F2,"") in the formula bar. Do not put quotation marks around C2, D2, E2, or F2.
Press Enter. If the date in A2 is today, the cell shows the combined text; if not, it stays blank.
Drag the fill handle down from the result cell to copy the formula to the rows that need the same date check.

Adjust the Formula When Column A Contains Dates with Times
Use this approach if A2 may include a time component or when you need a date-only comparison for today’s date.
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. Open the workbook in WPS Office: Launch WPS Office Spreadsheet and open the .xlsx file containing the broken formula.
- 2. Select the result cell: Click the cell where you need the corrected concatenation formula, such as G2.
- 3. Enter the formula: Type =IF(A2=TODAY(),C2&D2&E2&F2,"") into the formula bar.
- 4. Press Enter and test: Press Enter, then verify that only today’s date row returns the combined text.
- 5. Save the file: Save or save as .xlsx to keep the corrected formula and Excel compatibility.

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.




