Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

convert date format from weeks.days to format excel can read

0

Hello,

I am trying to get the average length of time for dates that are stored in excel as weeks.days

For example, 36 weeks 6 days is entered as 36.6

As you can see, this is a problem for finding the average! Is there a way to convert 36.6 into 36.86 (because 6 days is 86% of a week), so that I can find an actual average length of time?

Answer
Discuss

Answers

0
=TRUNC(A1)+RIGHT(A1)/7

Works for cell A1, change the cell reference as needed.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login