Number of weeks between 2 given dates.

building reports webintelligence
1

Hi All,

I need to calculate the number of weeks between 2 given dates.
I am planning to use:

=Round(DaysBetween(Date1;Date2) / 7;0)

Is this the only solution we have or do we have a better way to get count of number of days between 2 given dates.

Thanks,

MSR_BO (BOB member since 2009-05-01)

2

Hi,

That’s exactly what DaysBetween() function does.

Why do you need anything else? :?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Has Marek said…

The days between function will give you the days then devide by seven (or five for working days).

eg. =DaysBetween([first date], [second date])/7

That will give you the number of weeks.

Damo

Evil Miyagi :uk: (BOB member since 2006-03-06)

4

How is it different from the formula that the original poster uses? :roll_eyes:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

** Note to self **

Read and take note of the whole post before replying…

** End of note to self **

:hb:

Evil Miyagi :uk: (BOB member since 2006-03-06)