Is date in column within a 12 month period?

[creative999]

Hi

Need a formula which gives me a YES if the date in B5 is within a 365 day range.

Any suggestions?

 

[etaf]

=if(b5>today()-365,"yes","")

 

[creative999]

Apologise, just reread my question. It should been within the next 365 days.
The formula above returns a Yes even if the reference date is 9/8/2028

 

[etaf]

so in the future year

=if(AND(b5>=today(),b5<=today()+365),"yes","")