mjrlmr71297
New Member
- Joined
- Mar 20, 2009
- Messages
- 3
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.
=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.