=month(d2)
Solved/Closed
ramlalmeena
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013
-
Feb 19, 2013 at 06:32 AM
ramlalmeena Posts 3 Registration date Tuesday February 19, 2013 Status Member Last seen February 20, 2013 - Feb 20, 2013 at 04:25 AM
ramlalmeena Posts 3 Registration date Tuesday February 19, 2013 Status Member Last seen February 20, 2013 - Feb 20, 2013 at 04:25 AM
Related:
- =month(d2)
- Month calculator - Download - Calculators
- Convert mm/dd/yyyy to month and year in excel - Guide
- How much is netflix a month - Guide
- Netflix one month free - Guide
3 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 19, 2013 at 06:58 AM
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
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013
Feb 19, 2013 at 07:11 AM
Feb 19, 2013 at 07:11 AM
The empty cell in another release comes months 0
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 19, 2013 at 10:23 AM
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
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013
Feb 20, 2013 at 04:25 AM
Feb 20, 2013 at 04:25 AM
Thank you very much sir, my problem has been resolved thanks to a time
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 19, 2013 at 07:26 AM
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.
