Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Current year function
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 |
#2
|
|||
|
|||
Try: =YEAR(NOW())
(syntax issue ..) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Sam at JWP" <Sam at wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |