T
Tina
I hope someone can help....
I am trying to get statistics on whether date deadlines have been met. The
three columns I am working on are :-
the required by date (K5) (automatically calculated from elsewhere on the
sheet),
the actual date (L5) the task was completed,
A yes/no column (M5).
I have used this formula =IF(L5>=K5,"N","Y")
However, for some bizarre reason it is still giving me a "N" if the require
by date and the actual date are the same.
Also, when a task has not yet been completed, the "actual date" is blank,
but the yes/no column still shows a yes. I cant figure out how to use the if
"" stuff to keep it blank unless both required by and actual dates are filled
in.
Any help would be really appreciated.
I am trying to get statistics on whether date deadlines have been met. The
three columns I am working on are :-
the required by date (K5) (automatically calculated from elsewhere on the
sheet),
the actual date (L5) the task was completed,
A yes/no column (M5).
I have used this formula =IF(L5>=K5,"N","Y")
However, for some bizarre reason it is still giving me a "N" if the require
by date and the actual date are the same.
Also, when a task has not yet been completed, the "actual date" is blank,
but the yes/no column still shows a yes. I cant figure out how to use the if
"" stuff to keep it blank unless both required by and actual dates are filled
in.
Any help would be really appreciated.