Previous Topic Next Topic

=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
Hello,

Empty cell in Excel file has changed in the month, while 0 is 1 reply should have come to help please

3 replies

Answer 1 / 3
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
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.
0
Answer 2 / 3
ramlalmeena
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
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 509
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
0
ramlalmeena
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
0
Answer 3 / 3
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
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.
0