Well, I struggled with this for an hour or so until I finally found a solution...
our customer has a list of users with a date field with their Birthday.
He wishes to see the upcoming birthdays for users in the upcoming week.
The birthdate field holds the actual birthday of the user (i.e. July 24 1980), but he wants to see it as July 24 2008... July 24 2009... and so on.
Well, since we cannot use the [Today] field in calculated column (all tricks wont work - the field won't update!), I have conjured this solution that only asks for a yearly update to the column:
First, we have to create a calculated column that results in the current year birthdate
(from July 24 1980 to July 24 2008)
1 - create a date column to hold real birthday (named: BDay) or type date.
2 - create a calculate column to hold this year's BDay (named: YBDay).
3 - set the output type of the calculated value to "Date and Time"
4 - use this formula to generate its value:
Now, the rest is easy:
You create a view and set filter to 2 conditions:
where [this year birthday] >= [Today]
where [this year birthday] <= [Today] + 7
Now, you see all birthdays for the upcoming week!
Just remember - next year you will have to update the formula of the calculated field.
Hope this helps you - sure did saved me :)