Formula assistance request

[usmrncrps]

[TABLE="width: 500"]
<tbody>[TR]
[TD]TODAY[/TD]
[TD]DATE TRAINED[/TD]
[TD]DATE CERTIFY BY[/TD]
[TD]DATE CERTIFIED[/TD]
[TD]DAYS DELINQUENT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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?[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]TODAY[/TD]
[TD]DATE TRAINED[/TD]
[TD]DATE CERTIFY BY[/TD]
[TD]DATE CERTIFIED[/TD]
[TD]DAYS DELINQUENT[/TD]
[/TR]
[TR]
[TD]=TODAY()[/TD]
[TD]12.11.2016[/TD]
[TD]=B1+365[/TD]
[TD]12.18.2016[/TD]
[TD]=B1-A2-365[/TD]
[/TR]
</tbody>[/TABLE]


Something like this?