SMASE, Inc.;452269 Wrote:
currently i have a date such as this in a the field; 08/13/2009, i want
to
create another column and show only the year. how can this be done.
assistance is appreciated. working on this report now and due soon.
help.
say your date is in cell K17, then in any other cell:
=YEAR(K17)
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=125191