Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • 1
    I don't understand how you are getting decimal days. the DAYS function should give you exactly the number of days between 2 days. Maybe edit your question and add examples of data that give decimal days. Commented Jun 3 at 5:39
  • 1
    @jsotola - Writing an Excel formula in all capitals is allowed.
    – Ramhound
    Commented Jun 3 at 5:54
  • Dates are also intigers, but Excel can display them as a date, so if you just do date 2 - date 1 you should get an intiger, which should be the amount of days between the two.
    – Excellor
    Commented Jun 3 at 10:54
  • 1
    You cannot convert decimal months to exact number of days unless you know to which month the decimal portion applies. Commented Jun 3 at 13:22
  • a formula like this could find the number of days for a month in the year 2024: =DAY(EOMONTH(INT(monthFraction)&"/01/24",0)). I leave it up to you to modify/construct the rest of the formua.
    – gns100
    Commented Jun 3 at 16:02