calming.insanity
New Member
- Joined
- Apr 27, 2007
- Messages
- 22
I am having problems getting the MONTH() function to work. no matter what date i reference, it comes up with january for some reason. Any ideas?
=month(b2)
The reason month(b2) fails is because the Like Norie Said, the Month function returns a NUMBER Jan = 1, Feb = 2 etc...
so month(b2) will return a number from 1 - 12.
in excel date language,
1 = Jan 1 1900
2 = Jan 2 1900
3 = Jan 3 1900