Counting Weeks in a year

F

Frances C

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.
 
H

Harlan Grove

Frances C said:
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.
Click to expand...

=INT((LaterDate-EarlierDate)/7)

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

Frances C

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!
 
Top