A Formula to calculate expiration today +90 days out

Is there a formula I can use that will calculate if a contract has expired (or is going to expire) Something that has a date of 1/1/12 until today and then 90 days from today? I know that seems like a lot... even if it's just something that will produce a True or False or if we can't get someting that goes from 1/1/12 to 90 days out then what about something that goes from todays date to 90 days out?

For example:

A B C
1 company 3/1/12 ???Formula???
2 company 2 1/1/12
3 company 3 5/2/12



Any help if any would be great!! Thank you

Hi Jenn,

I'm not quite understanding exactly what you want to see, but you can use the TODAY() and simple math functions to calculate dates. For example, if B1 has 1/1/2012 in it, in C1 you could use

=B1+90

That would return the date 90 days after the date in B1.

=TODAY()+90

That would return the date 90 days after today. The TODAY() function is volatile, and automatically updates - so if you open it tomorrow that cell will be different (3/30/2012 + 90 vs. 3/31/2012 + 90).

If that doesn't get you on the right track, try posting a sample that shows your current layout and your expected results - and why those are the expected results.