=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

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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