Conditional formatting date

[Meagz24]

Hi there,

I'm after some help with conditional formatting.

I have a date in the past and I would like a colour to show when that date is 12mths old and a seperate colour to show when that date is 11mths old, please help!

Thanks

[dredwolf]

try :
=(today()-A1)>=365 for first
=And((today()-A1)<365,(today()-A1)>=334.4) for the second

Hope this helps

:note- this is a rough calculation, the assumption being 30.4 days in a month

Edit..

proper value for 11 months..based on my assumptio, in red..worked it backwaards first time..sorry

[:) Sixthsense :)]

Use the below formula's in your conditional formatting

To check whether the date is 12 Moths Old

Please Login or Register  to view this content.

To check whether the date is 11 Moths Old

Please Login or Register  to view this content.

[Meagz24]

Great help, thanks guys!

[dredwolf]

You are welcome