Hi All,

I was wondering how I could return number of weeks between two dates but getting the result including at least 4 decimal places. I know that the datediff function returns an integer so I'm guessing this function won't do the job. I'm working in Excel by the way.

I know I could just return the number of days and then divide by seven and put that into a double variable but I need the decimal places to change every time I refresh them and doing it this way they would only change once a day when the day value changes. So I guess the question is also can I return the day value in decimal places

Does anyone have any suggestions on how to tackle this?

Thanks

Lloyd