I am looking for help, I have two dates that I need to put in a 3rd collumn depending on 3 scenarios.

F2 = Due Date (This will always have a date)
H2 = Published Date (This will be null until published then have the publish date)
I2 = On Time (This is where I am calculateing this needs to equal Not Due, Ontime, Past Due)

I have not been able to work through the appropirate if statements to make this work, I try to compare against today and cant get anything to work from that point. Any thoughts from the community?