Kev,
=IF(B7<"","RECEIVED",IF(A2B4+14,"DUE","Not Yet Due"))
Wasn't sure what you wanted when it wasn't either received or due. You
could leave the cell blank by using
=IF(B7<"","RECEIVED",IF(A2B4+14,"DUE",""))
HTH,
Bernie
MS Excel MVP
"kevhatch" wrote in message
...
Hi, I am setting up a register to show when/if my drivers have handed in
their Tacho charts on time.
So far I have this formula at C7 and now I'm stuck :-(
=IF(A2B4+14,"DUE")
A2 is =today()
B4 is whatever the week commencing date may be.
What I would like is for "DUE" to appear in C7 14 days after the week
commencing date at B4 (so far so good!!), but when I put the number of
charts
received in B7 "DUE" would be changed to "RECEIVED".
Hope it makes sense and you can help.
Thx
|