I have Attached Excel Dictionary
MONTH |
|
|||||||||||||||||||
Original Date | Month | |||||||||||||||||||
1-Jan-98 | 1 | =MONTH(C4) | ||||||||||||||||||
1-Jan-98 | January | =MONTH(C5) | ||||||||||||||||||
What Does It Do? | ||||||||||||||||||||
This function extracts the month from a complete date. | ||||||||||||||||||||
Syntax | ||||||||||||||||||||
=MONTH(Date) | ||||||||||||||||||||
Formatting | ||||||||||||||||||||
Normally the result will be a number, but this can be formatted to show the actual | ||||||||||||||||||||
month by using Format,Cells,Number,Custom and using the code mmm or mmmm. | ||||||||||||||||||||
Example | ||||||||||||||||||||
The =MONTH function has been used to calculate the name of the month for your birthday. | ||||||||||||||||||||
Please enter your date of birth in the format dd/mm/yy | 3/25/1962 | |||||||||||||||||||
You were born in | January | =MONTH(F20) | ||||||||||||||||||
Click Here To Download Excel Dictionary
Whenever a company announces employee training session for skills development then it is supposed to…
If you are planning to immediately resign from your job but you can have your…
If you have been invited to serve in an honorary position at any institution and…
Violating the policy of the company will not be accepted by any organization and if…
Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…
If there is retaliation that you have observed in a particular team or department then…