DATEDIF and Chain of Dates

[dasbear3]

Hi everyone! I’m working with a process chain that includes several dates. <o></o>
<o></o>
Explanation of Cells:<o></o>
A1: Date for Initial Review (Should not take more than four days to escalate)<o></o>
B1: Contains formula to determine whether timeframe of A1 is “OVER” or “WITHIN LIMITS”<o></o>
C1: Date for Financial Review (Next date in process)<o></o>
<o></o>
As it currently stands, B1 holds this formula:<o></o>
<o></o>
[highlight]=IF(ISBLANK(A1),””,IF(DATEDIF(A1,TODAY(),”d”)>4,”OVER”,”WITHIN LIMITS”))[/highlight]<o></o>
<o></o>
I wanted to add an additional part which uses C1. <o></o>
<o></o>

• If C1 has a date occurring after A1, then B1 populates “IN PROGRESS”.
  [*]However, if C1 has a date occurring before A1, then B1 populates “ERROR”. <o></o>
  
  [*]If C1 is blank, then B1 will either show the “OVER” or “WITHIN LIMITS” like it currently does.

<o></o>
<o></o>
Any ideas? Thank you for your time!<o></o>

 

[Peter_SSs]

You don't need DATEDIF to calculate the number of days between two dates, you can just subtract.

So, try this in B1

=IF(A1="","",IF(C1="",IF(TODAY()-A1>4,"OVER","WITHIN LIMITS"),IF(C1< A1,"ERROR","INPROGRESS")))

 

[dasbear3]

Peter_SSs,

This is perfect!! Thank you for clarifying about DATEDIF; it's always better to be as simple as possible.

Thanks again!