=month(d2)

[Solved/Closed]
Report
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013
-
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013
-
Hello,

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

3 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013

The empty cell in another release comes months 0
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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
Posts
3
Registration date
Tuesday February 19, 2013
Status
Member
Last seen
February 20, 2013

Thank you very much sir, my problem has been resolved thanks to a time
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.