How can i format the =now() to just display the current year? Thanks
D Douglas J. Steele Jul 31, 2007 #2 Format(Now(), "yyyy") will return a string version of the current year, DatePart("yyyy", Now()) or Year(Now()) will return a numeric version.
Format(Now(), "yyyy") will return a string version of the current year, DatePart("yyyy", Now()) or Year(Now()) will return a numeric version.
