Year Calculation
Or, if you want the actual value to be 2008, then use =YEAR(A1)
Tony
On Jan 4, 9:20 am, AmyBC wrote:
How can I create a formula to calculate a year based on a date? For
example, I have a cell that includes the following date: 3/1/08. I would
like to create a formula in the adjacent cell that calculates the four digit
year that corresponds with the date: 2008.
|