=month(d2)
Solved/Closed
ramlalmeena
ramlalmeena
- Posts
- 3
- Registration date
- Tuesday February 19, 2013
- Status
- Member
- Last seen
- February 20, 2013
ramlalmeena
- Posts
- 3
- Registration date
- Tuesday February 19, 2013
- Status
- Member
- Last seen
- February 20, 2013
3 replies
Zohaib R
Feb 19, 2013 at 06:58 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 19, 2013 at 06:58 AM
Hi ramlalmeena,
MONTH(serial_number) worksheet function in Microsoft Excel returns the month of a date represented by a serial number. In your formula it should return the month of the date stored in cell D2. For example, if D2 has 02/19/2013, then =MONTH(D2) will return 2 because this date falls in the month of February (2nd month of the year). If there is no value stored in D2, it will return 1 because Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
Kindly get back if there are any further queries.
MONTH(serial_number) worksheet function in Microsoft Excel returns the month of a date represented by a serial number. In your formula it should return the month of the date stored in cell D2. For example, if D2 has 02/19/2013, then =MONTH(D2) will return 2 because this date falls in the month of February (2nd month of the year). If there is no value stored in D2, it will return 1 because Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.
Kindly get back if there are any further queries.
ramlalmeena
Feb 19, 2013 at 07:11 AM
- Posts
- 3
- Registration date
- Tuesday February 19, 2013
- Status
- Member
- Last seen
- February 20, 2013
Feb 19, 2013 at 07:11 AM
The empty cell in another release comes months 0
TrowaD
Feb 19, 2013 at 10:23 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 19, 2013 at 10:23 AM
Hi ramlalmeena,
If you want to return 0 when cell is empty or contains 0, use this formula:
=IF(OR(D2="",D2=0),0,MONTH(D2))
Best regards,
Trowa
If you want to return 0 when cell is empty or contains 0, use this formula:
=IF(OR(D2="",D2=0),0,MONTH(D2))
Best regards,
Trowa
ramlalmeena
Feb 20, 2013 at 04:25 AM
- Posts
- 3
- Registration date
- Tuesday February 19, 2013
- Status
- Member
- Last seen
- February 20, 2013
Feb 20, 2013 at 04:25 AM
Thank you very much sir, my problem has been resolved thanks to a time
Zohaib R
Feb 19, 2013 at 07:26 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 19, 2013 at 07:26 AM
Hi ramlalmeena,
So that I can look at the file, please upload it to the below mentioned link. Also in your reply please include the version of Microsoft Excel you are using such as Excel 2003, 2007, 2010, etc.
https://authentification.site
Note: Before you upload any files please make sure there is no personal or confidential information contained in it.
Please do write back to us.
So that I can look at the file, please upload it to the below mentioned link. Also in your reply please include the version of Microsoft Excel you are using such as Excel 2003, 2007, 2010, etc.
https://authentification.site
Note: Before you upload any files please make sure there is no personal or confidential information contained in it.
Please do write back to us.