Timeline for Convert month dates (with decimals) to days in Excel
Current License: CC BY-SA 4.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 7 at 22:05 | answer | added | AJD | timeline score: 0 | |
Jun 4 at 2:33 | answer | added | Hans Schulze | timeline score: 1 | |
Jun 3 at 16:02 | comment | added | gns100 |
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.
|
|
Jun 3 at 13:22 | comment | added | Ron Rosenfeld | You cannot convert decimal months to exact number of days unless you know to which month the decimal portion applies. | |
Jun 3 at 10:54 | comment | added | Excellor |
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.
|
|
Jun 3 at 5:54 | comment | added | Ramhound | @jsotola - Writing an Excel formula in all capitals is allowed. | |
Jun 3 at 5:39 | comment | added | Reddy Lutonadio | 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. | |
Jun 3 at 5:11 | review | Close votes | |||
Jun 16 at 2:01 | |||||
Jun 3 at 5:04 | history | edited | Journeyman Geek♦ | CC BY-SA 4.0 |
less shouty title
|
Jun 3 at 3:53 | history | asked | Camila Sanchez | CC BY-SA 4.0 |