>>Isn't it the same as
>>
lnYear = INT(YEAR(DATE())%100)+1
?
>>
>
>Could you please give me formula for the century?
If the year is 2005, you can get the 2-digit year (without the century) with:
2005 % 100
and the century with:
int(2005 / 100)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)