Multiple if Statement - Auto Population

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

I have the following set up in a spreadsheet:

Today 17/05/2004 (Cell A1)

Date Status
11/05/2004 (Cell A5) Due in 1 week
11/04/2004 Overdue
11/06/2004 Not due

I'm trying to use a set of if statements to populate the
status field. Here's what I have so far

=IF($A$1<=A5,"Not due",IF($A$1-A5<=7,"Due in within a
week",IF($A$1>=A5,"Overdue")))

Logic tells me that if 11/05/04 is equal or 7 days away
from 17/05/04 then it's due in 1 week or less. If it's
beyond that date it's not due and if it's below that date
it's overdue. Does this makes sense? Cos it aint
working.. lol :S
 
Hi
the following should work:
=IF($A$1>A5,"Overdue",IF($A$1-7>=A5,"Due within a week","Not due"))
 
Thanks Frank.

I've tried this. The cell populates with the overdue and
not due part of this argument, but does not pick up the
due within a week part.

Darren :S
 
Hi Darren,

try:

=IF(A5<$A$1,"Overdue",IF(A5<$A$1+7,"Due within a week","Not due"))

Hope this helps!
 
Back
Top