I was trying to figure out a way to calculate future years. I have pay periods based on this year, but need to calculate next years' pay period. The formula I have now is =year(today()). How can I use this to show me next year?
Thanks..
I was trying to figure out a way to calculate future years. I have pay periods based on this year, but need to calculate next years' pay period. The formula I have now is =year(today()). How can I use this to show me next year?
Thanks..
How about
=year(today())+1
Ah yes....That'll work. Thanx
LT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks