Formula - Calculate difference in dates based on multiple criteria

[powercell99]

Need help calculating the number of days between dates for particular statuses. Each record has multiple statuses (status field is Column B) and dates associated with that status (date field is Column C). a simple datedif() would be able to compare dates in different columns or different rows. How can i add additional criteria to the formula to capture the number of days between status "Approved" and status "Requested"?

 

[AlanY]

try

=datedif(VLOOKUP("Approved",B:C,2,0),VLOOKUP("Requested",B:C,2,0),"d")

 

[powercell99]

thanks. Thats a great help!

 

[AlanY]

You're welcome