Good Afternoon, I'm trying to build a calculated column in SharePoint 2010 that returns 1 of 3 choices based on a date.
The date field is called "Requested Date" and I need to have the column say "Less Than 6" "Greater than 6 Less than 12" and "Greater Than 12" if that is even possible.
I need these options for the requested date to be:
- Less than 6 months old
- More than 6 months old but less than 12 months old
- More than 12 months old