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.

A bit more info perhaps.

--
Don Guillett
SalesAid Software

"AmyBC" wrote in message
...
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.

=YEAR(A1)

or

=--TEXT(A1,"yyyy")

or

=A1

and format as yyyy

the last one only changes the display, the first 2 are 4 digit numbers
for the year


Regards,

Peo Sjoblom


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.

In B1 =A1
Format your cell as: yyyy

"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.

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.