# how do I add 90 days to a calculated column?

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following:

``````If column A is blank, and column B is greater than 90 days from today then "No".
If column A is blank, and column B is greater than 83 days from today then "Upcoming".
If column A is blank, and column B is less than or equal to 83 days from today then "Yes".
If Column A is less than or equal to 90 days from column B then "Yes".
Otherwise "no".
``````

I had the following, but it's not working:

``````=IF(AND([TPM/TPC Complete]="",TODAY()-[RA Date]>90),"NO"=IF(AND([TPM/TPC Complete]="",TODAY()-[RA Date]>83),"UPCOMING"=IF(AND([TPM/TPC Complete]="",TODAY()-[RA Date]<=83),"YES"=IF([TPM/TPC Complete]-[RA Date]<=90,"Y","N"))))
``````

`DATEDIF([Today], [Column1],"d")`
BUT, using `[Today]` is pointless in a SharePoint calculated column because the value of it will only change when the item is changed.
Note: you seem to have a syntax error in your formula anyway. There should only be one `=` and that should be at the beginning of the formula. You would need to replace the other `=`'s with a comma `,`