See my last posting David, as I did mention that I got Barry's formula to
work, however, what I was looking for was for the "NO" flag to trigger when
BOTH X4 & Y4 are blank. Barry's formula triggers if EITHER X4 or Y4 is blank.
I also mentioned that I needed formula which would have cell AA4 remain
"blank" if either of the following conditions occur:
1) Dates appear in cell X4 AND Y4, but the date in cell Y4 has not yet
passed (e.g. today is not greater than the date in cell Y4).
2) If cell Z4 is blank
I use cell Z4 to indicate the class section (Saturday, Sunday). If a client
hasn't been assigned to a class section, and NO dates are posted in X4 and
Y4, than cell AA4 should also remain blank. If a client has been assigned to
a class I would leave cell Z4 blank. If a client has been assigned to a
class, and failed to attend, I would remove the dates in X4 and Y4, but leave
the class section information intact. Thus, cell AA4 (in this scenario) would
flag "NO', to indicate the class hasn't been completed by the student.
Again, thank you anyone for feedback. I very much appreciate it.
Dan
"David Biddulph" wrote:
Barry's formula of =IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No") cannot
return TRUE.
Perhaps you tried to type in the formula and did so incorrectly?
Don't try to retype; use copy (from the newsgroup) and paste (into your
spreadsheet formula).
--
David Biddulph
"Danny Boy" wrote in message
...
Hi Barry!
Thanks for the suggestion about EDATE. I can be numb sometime (I'm still
an
Excel newbie). I tried your formula, but it did not work. It merely gave
me
the result (in cell AA4) of TRUE, as opposed to identifying YES (class has
been completed), or NO (class has not been completed).
Again, if a date is entered into both cells X4 & Y4, and TODAY is greater
than the date in cell Y4, the flag in cell AA4 should say YES (indicating
that the class has been completed). If however, a student doesn't complete
their class, I remove the dates from cells X4 and Y4, and then the NO flag
should appear in cell AA4 (indicating that the class has not been
completed).
I also forgot to mention that cell AA4 should remain "blank" if either:
1) Dates appear in cell X4 AND Y4, but the date in cell Y4 has not yet
passed (e.g. today is not greater than the date in cell Y4).
2) If cell Z4 is blank (I forgot to mention that in my original formula).
I
use cell Z4 to indicate the class section (Saturday, Sunday).
Again, thank you!
Dan
"barry houdini" wrote:
Hello Dan, I don't think you need EDATE, using EDATE(Y4,0) is just the
same as using Y4. Try this version
=IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No")
--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile:
http://www.thecodecage.com/forumz/member.php?userid=72
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=121219