Function based on blank cell and date past due
Ok, for every blank cell in column is there corresponding data in columns C
and D or might they also be blank?
If there are many cells that meet these conditions this will take a very
complicated formula.
--
Biff
Microsoft Excel MVP
"Paul" wrote in message
...
I think that there will be many blank cells. But that is why step two must
look at a due date to see if it is overdue.
"T. Valko" wrote:
Look down a column(A) for any blank cell
Is there only one blank cell in column A?
--
Biff
Microsoft Excel MVP
"Paul" wrote in message
...
I am needing to get a function to do the following:
Look down a column(A) for any blank cell, then for that blank cell look
in
the cell to the right in column B and see if the date is past today.
If
this
is true, I want the values of the corresponding cells in column C and D
concantenated and inserted into cell F3.
Another major issue is that the value in the cell for column D is a
date
and
when it is inserted it comes as the number value instead of the typical
date.
Thank you for any help,
-- Paul
|