0

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"))))
0

To get the number of days between two dates in a calculated column we use this:

DATEDIF([Today], [Column1],"d")

See here a reference on calculated column formulas.

BUT, using [Today] is pointless in a SharePoint calculated column because the value of it will only change when the item is changed.

See here loads of resources on how you can get around this issue.

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 ,

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.