A FIXED calculated field might do this for you. Try something like:
This might not be appropriate, depends what you want to do with it exactly.
Another formula that might do it is:
Note these should work in Tableau 10, if using Tableau 9 you would need to create DAY([Date]) as a separate calculated field to reference.