Counting Weeks in a year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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!
 
=IF(COUNT(LaterDate,Earlier Date)=2,INT((LaterDate-EarlierDate)/7),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workday calendar 1
Date Diff - excluding working days 2
Calculate next workday after adding calendar days to date in cell 13
Access Dcount function in access 0
Formula to tell day of week 2
number of week days in a period of time 5
Countif function with multiple column criteria? 8
Editing Weekly Inventory 1

Back
Top