I have 2 dates value in Excel. They are ; 24Jan hrs 00secs and ; 15May hrs 46secs. I want to get the number of days between these 2 dates.

The value returned was VALUE! If you have the string in cell A1use the formula to convert it to an actual date before finding the difference. By posting your answer, you agree to the privacy policy and terms of service.

Getting workdays by month using VBA

Stack Overflow Questions Developer Jobs Documentation beta Tags Users. Sign up or log in to customize your list. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us.

Log In Sign Up. Join the Stack Overflow Community.

Stack Overflow is a community of 7. Join binary option binex it only takes a minute: Get number of days between 2 dates of this format in Excel Ask Question. What Excel formula or VBA function can I use to get the number of days between the 2 dates?

Nirav Madariya, I confirm it is not sap bdc call transaction options number of business days between two dates vba lack of width. DateDif function accepts the dates as arguments and the error returned simply means the cell G and G are not dates or dates as Text.

calculate working days between 2 dates | dBforums – Everything on Databases, Design, Developers and Administrators

What do you get True or False. If you get False that means those are not dates. Excel treats dates as numbers. I added a solution. See if that produces the desired output.

Thanks for the help. However, the answer returned is There are surely more than 21 days between ; and ; I discovered how to get the correct answer.

A little modification to your answer. Instead of using "md", using "d". I have edited your answer.

I used "md" because it was in your original formula and thought that is what you want to use an argument so didn't change that. Anyways glad that your issue has been resolved.

Gowtham Shiva 2, 1 2 Sign up or log in StackExchange. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Excel formula: Get workdays between dates | Exceljet

Stack Overflow works best with JavaScript enabled. MathOverflow Mathematics Cross Validated stats Theoretical Computer Science Physics Chemistry Biology Computer Science Philosophy more 3. Meta Stack Exchange Stack Apps Area 51 Stack Overflow Talent.