Originally Posted by Misty Sunshine

I need to have excel calculate a formula each month from a stationary date which I can do with =date however at the beginning of each new year I need the stationary date's year to change. Is there a way to do this?