Weeks between two Dates

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

Is there a function that calculates the number of weeks between two dates? Or
am I going to have to use (A2-A3)/7.
 
You could use WEEKNUM:
=WEEKNUM(A2)-WEEKNUM(A3)

It should all work about the same. Your original idea is probaly easier to
understand.
 
Thanks PJ.

PJFry said:
You could use WEEKNUM:
=WEEKNUM(A2)-WEEKNUM(A3)

It should all work about the same. Your original idea is probaly easier to
understand.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.
Click to expand...
 

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

Subtracting AD and/or BC dates 21
Pivot table macro filter data between yesterday and today (date+time) 0
counting weeks and days between dates 7
Calc Number of Months PER YEAR Between Dates 2
Counting number of Sundays 7
Help with dates 5
Excel =SUM(A1=A1+B1) 0
Save a date as a variable and run/convert formula against the vari 2

Back
Top