Formula assistance request

[usmrncrps]

TODAY	DATE TRAINED	DATE CERTIFY BY	DATE CERTIFIED	DAYS DELINQUENT

<tbody>
</tbody>

I'm looking for assistance with a formula that will calculate days delinquent. DATE TRAINED can be blank if not trained. DATE CERTIFY BY is one year (365 days) after date entered in DATE TRAINED. DATE CERTIFIED is actual date certified (acceptable to be before or after DATE CERTIFY BY). DAYS DELINQUENT are the number of days from DATE TRAINED to TODAY (minus) 365 days.

Thanks for any help.

 

[Legacy 143009]

You've given your own answers. What are you asking for?

TODAY	DATE TRAINED	DATE CERTIFY BY	DATE CERTIFIED	DAYS DELINQUENT
=TODAY()	12.11.2016	=B1+365	12.18.2016	=B1-A2-365

<tbody>
</tbody>

Something like this?