Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft excel, IF formula

Microsoft excel, IF formula

ResolvedVersion 365

Mon 16 Dec 2024, 16:00 Delegate Luke said...

Luke has attended:
Excel Intermediate course

Microsoft excel, IF formula

Hi, I want to get a cell to read 'completed' if the cell next to it has a date populated in it. What is the formula required for that?

Tue 17 Dec 2024, 11:22 Trainer Marius said...

RE: Microsoft excel, IF formula

Hello Luke,

Thank you for your question. While there is no specific function in Excel which tests for dates, you can use =ISNUMBER, since dates have numeric values.

The IF formula would read:

=IF(ISNUMBER(A1),"Completed","")

where A1 is the cell being tested.

I hope this helps.

Kind regards
Marius Barnard
STL

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Microsoft excel, IF formula

Microsoft excel, IF formula

RE: Microsoft excel, IF formula

Excel articles

Excel tip:

Adding date and time