=YEAR(TODAY()) will result in 2016
But is it possible to prevent the user to change this, when the user changes years on the Windows control panel?
So if one adds 2 years in the Control Panel, formula above will still be 2016.
=YEAR(TODAY()) will result in 2016
But is it possible to prevent the user to change this, when the user changes years on the Windows control panel?
So if one adds 2 years in the Control Panel, formula above will still be 2016.
If you want the number fixed at 2016, then put that number in the cell rather than a formula.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks