| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weeks between two Dates
Is there a function that calculates the number of weeks between two dates? Or
am I going to have to use (A2-A3)/7. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weeks between two Dates
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. "Ayo" wrote: Is there a function that calculates the number of weeks between two dates? Or am I going to have to use (A2-A3)/7. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weeks between two Dates
Thanks PJ.
"PJFry" wrote: 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. "Ayo" wrote: Is there a function that calculates the number of weeks between two dates? Or am I going to have to use (A2-A3)/7. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Weeks between two Dates
Be careful if those two dates don't fall in the same year.
Ayo wrote: Thanks PJ. "PJFry" wrote: 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. "Ayo" wrote: Is there a function that calculates the number of weeks between two dates? Or am I going to have to use (A2-A3)/7. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for # weeks between 2 dates | Excel Discussion (Misc queries) | |||
| Difference in Weeks between 2 dates | Excel Worksheet Functions | |||
| Weeks and dates | Excel Worksheet Functions | |||
| Converting Dates to Weeks | Excel Worksheet Functions | |||
| Weeks between dates | Excel Worksheet Functions | |||
Linear Mode
