This seems like a very simple question, but I am quite confused. I am using standard Contract object, and I created a formula field
Half Year Expiration Date which has a formula of
EndDate - 182.5. 182.5 is the total of all days in 6 months (given that contract term is 12 months) based on my estimate.
How do I use this in a report such that all contracts with six months remaining before their expiration dates are displayed?