Counting Weeks in a year
 

What formula can I use to count the amount of week between two dates in a
year. I do not want to count workdays, I want to count full weeks.

Counting Weeks in a year
 

"Frances C" wrote...
What formula can I use to count the amount of week between two dates in a
year. I do not want to count workdays, I want to count full weeks.

=INT((LaterDate-EarlierDate)/7)

will count full weeks between EarlierDate and LaterDate and ignore remaining
days.

Counting Weeks in a year
 

How can I make it invisible, I do not want a cero to show on the cell if I
have not enter the dates on the other cells. Thanks for your help you are
great!

"Harlan Grove" wrote:

"Frances C" wrote...
What formula can I use to count the amount of week between two dates in a
year. I do not want to count workdays, I want to count full weeks.

=INT((LaterDate-EarlierDate)/7)

will count full weeks between EarlierDate and LaterDate and ignore remaining
days.

Counting Weeks in a year
 

=IF(COUNT(LaterDate,Earlier Date)=2,INT((LaterDate-EarlierDate)/7),"")
--
David Biddulph

"Frances C" wrote in message
...
How can I make it invisible, I do not want a cero to show on the cell if I
have not enter the dates on the other cells. Thanks for your help you are
great!

"Harlan Grove" wrote:

"Frances C" wrote...
What formula can I use to count the amount of week between two dates in
a
year. I do not want to count workdays, I want to count full weeks.

=INT((LaterDate-EarlierDate)/7)

will count full weeks between EarlierDate and LaterDate and ignore
remaining
days.