Date results problem

[mjrlmr71297]

today() = 3/20/2009

=year(today())

When using this formula the result I get is 2009, which is correct.

When I change the format to get just a 2-digit date ie 09, the result I get is 05

similar issue when using =month()

I don not understand why this is happening. any help is apprecaited.

 

[texasalynn]

it works ok for me

Excel Workbook
	A
1	3/20/09
2	2009
3	3
Sheet2

Are you using the same as I have shown here?

 

[mjrlmr71297]

it screws up when i change to a custom format so that I only get a 2 digit date ex: I want 09 for the year and 03 for the month

 

[DonkeyOte]

Dates are integers, YEAR(TODAY()) = integer 2009 which equates to date 1st July 1905 which is why you get 05, you want to either use:
=TEXT(TODAY(),"yy")

or better yet just =TODAY() and format cell to custom format of: yy

 

[mjrlmr71297]

thank you