formula that works out 6 months from date

[ea223]

I want a formula that writes yes when the date in column A is within 6 months from today's date....
thanks

[vlady]

maybe you can use it like this as per my understanding

=DATE(YEAR(TODAY()),MONTH(TODAY())+6,DAY(TODAY()))>A1

[ea223]

this seems to work! thank you. is there anyway i can get it to not show as TRUE if the date is column A is past today's date?

[FDibbins]

if you want 6 months all the time, use this...
=TODAY()-365.25/2
you can change the last part to adjust for more/less than 6 mths

edit: try =if(A1>=today(),"",TODAY()-365.25/2)

[Steve N.]

In cell B2

=IF(A2>TODAY()+182.625,"","Yes")