Hello!
I know you cannot split a week in half as such but is there a way to calculate the number of weeks between two dates to the nearest half week?
=ROUND((F11-F10)/7,2)
Using this returns the 28.4 in my current example but I would want 28.5
Hope that makes sense and thank you for your help in advance as always!
I know you cannot split a week in half as such but is there a way to calculate the number of weeks between two dates to the nearest half week?
=ROUND((F11-F10)/7,2)
Using this returns the 28.4 in my current example but I would want 28.5
Hope that makes sense and thank you for your help in advance as always!