Number of weeks between two dates to nearest half week

[smods]

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!

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=CEILING((F11-F10)/7,0.5)

 

[Joe4]

Try using the MROUND function, maybe, i.e.

=MROUND((F11-F10)/7,0.5)

 

[Joe4]

Just note there is a difference to the solutions proposed.

The CEILING function will ALWAYS round up to the next nearest multiple.
The MROUND function will round to the next nearest multiple (up or down).

If the value was 1.1, CEILING would return 1.5 and MROUND would return 1.

Use whichever one does what you want.