Current year function

[Sam at JWP]

Hi there,

I am wanting to know what function I use to get the current year for use in
a formula?
I have tried 'year(now)' but it does not work. Any tips?

Thanks
Sam

[BigPapaMurf]

Try this one...

=YEAR(TODAY())

[BigPapaMurf]

wow, thats old, sorry

[FDibbins]

wow, thats old, sorry

haha been there, done that. Still good feedback though, thanks

[bebo021999]

Was it an impossible mission? The YEAR function still working now.
No solution within 15 years?
Where were you, Excel gurus?
Thanks for quite new excel helper who put an end on it.

[FDibbins]

Quang, I guess it just fell through the cracks, got pushed down the list in probably a very busy day?