Not fully understanding the exact requirement but Excel "dates" are simply fractional numbers where a unit of 1 is a whole day. 0.5 is 12 hours etc.

So to keep it simple just look for hire dates at least 180 days before the post date?

"Post date - hired date > 180"

And use the $B$32 for your constant (in your DATEDIF) so you can fill down without Excel auto incrementing it.

Or just calculate the "minimum" hire date (B32 = B33-180) and compare directly with the hire date.