Date Calculations

[paulcherianc]

Hi,

can anyone help me to fix the following formula. I have attached a sample for better understanding.
I want to see the following results on the attached sheet

Grace Period (90 days after renewal date)
Valid (<=Renewal Date)
Expired (>Grace Date)

Can anyone build the logic.

 

[Hui]

D6: =IF($C$2<B6, "Valid",IF($C$2>C6,"Expired","Grace"))
copy down

 

[paulcherianc]

D6: =IF($C$2<B6, "Valid",IF($C$2>C6,"Expired","Grace"))
copy down

Hey Thanks Hui.

Thanks for your time!