Get instant live expert help on convert days to months in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Can you convert actual days of the work for the years to months or weeks
Solved by D. F. in 14 mins
I am trying to calculate days in excel to month and days and it seem like the calculations if off by some months or days. How can I fix this?
Solved by O. A. in 27 mins
I tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
Hello,
Looking to convert dates that are listed in 5 digit numbers. dates with double digit months are 6 digits. An example would be 31618 to convert to 03/16/18. There are many different dates so I would love to be able to put a formula that will account for all of them. For example, the second date in table is 40518, 41218, 41718.
From there I want to be able to subtract 7 days from that date for all to account for a ship date. 7 days being the average transit.
Thank you!
Solved by S. A. in 27 mins
Hi- I am trying to calculate full months for 30 days and if the months does not reach the full month than it would calculate calendar days. EX: 2/1/18-3/1/18=30 days
2/8/18/3/1/18=21 days
Solved by Z. C. in 23 mins