Can't get your Calculated Column to use the Today or Me functions?
Calculated columns cannot contain volatile functions like Today and Me.
By default SharePoint doesn't allow you to use the Today and Me functions within calculated columns.
Trick SharePoint by doing the following:
1) Create a new column in your list titled "Today" if you're working with dates or "Me" if you're working with people and groups. A Single line of text will do for the field type.
2) Go to your Calculated Column and enter the formula that contains the Today or Me functions and hit OK to save the formula and column settings.
3) Delete the Today or Me column that you originally created in Step #1 above.
Now you have a working Calculated Column with the Today or Me function.