Formula to display text depending upon date entered in a cell

  • Thread starter Rod from B.C. Government
  • Start date
R

Rod from B.C. Government

I thought this would be simple, but it has defeated me.

Assume that cells in column A are used to capture a future due date. In
column B, I need a formula that will display "Not Due Yet" if the date in
column A hasn't been reached, or "To Do" if we are at or past the date.

I was able to write a formula to do this successfully, but for some reason
it defaults to "To Do" on the rows where there is no entry in column A. I
tried using the ISBLANK function, but the problem is that the cell has a
formula in it that brings the text over from another worksheet, so I suppose
it isn't truly a blank cell.
 
G

Gord Dibben

Always helps us if you post the actual formula but maybe..........?

=IF(A1="","",yourformula)


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Formula to add depending upon value entered 4
Locking a cell reference in a formula 1
Testing a cell value for a specific weekday. 3
Hiding a cell with a formula. 2
help with formula for last input in column 6
activate formula when adjacent cell populated 4
Workday Formula to include date 0

Top