Adding week numbers in different years
- Thread starter Jejo
- Start date
kbschmidt77
New Member
Jejo and SirJB7... could i please ask a question in regards to your above formula's? I am trying to do a similar task and wondering if you would have suggestions on the formula?
Example:
I have a project that starts on January 15, 2010 and ends on January 15, 2012. So I know that 01/15/10 is week number 2. Then I also know that 01/15/12 is week number 3. I have a list of tasks that occurred during this timeline and need to calculate the NUMBER OF WEEKS FROM END DATE (01/15/12) each task occurred.
Do you have any suggestions?
Thank you in advance.
Example:
I have a project that starts on January 15, 2010 and ends on January 15, 2012. So I know that 01/15/10 is week number 2. Then I also know that 01/15/12 is week number 3. I have a list of tasks that occurred during this timeline and need to calculate the NUMBER OF WEEKS FROM END DATE (01/15/12) each task occurred.
Do you have any suggestions?
Thank you in advance.
kbschmidt77,
In the future, it would be better to start a new thread for a new question, rather than appending onto another thread (especially one that's not current). For your question, I believe the formula is simply:
=INT((EndDate - TaskDate)/7)
to get the number of whole weeks between task date and end date (1/15/2012). If you want decimals, remove the INT function.
In the future, it would be better to start a new thread for a new question, rather than appending onto another thread (especially one that's not current). For your question, I believe the formula is simply:
=INT((EndDate - TaskDate)/7)
to get the number of whole weeks between task date and end date (1/15/2012). If you want decimals, remove the INT function.
SirJB7
Excel Rōnin
Hi, kbschmidt77!
Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
And about your question:
If you don't get involved with WeekNum values in individual cells and if they're only part of your formulas and calculations, I'd strongly suggest to try this:
=(B2-A2)/7
Rounding up or down with ROUND, ROUNDUP or ROUNDDOWN functions if needed integer values and wants to round symmetrically, to next integer or truncate, respectively. They're all available since 2003 version at least.
Regards!
Perhaps you'd want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).
And about your question:
If you don't get involved with WeekNum values in individual cells and if they're only part of your formulas and calculations, I'd strongly suggest to try this:
=(B2-A2)/7
Rounding up or down with ROUND, ROUNDUP or ROUNDDOWN functions if needed integer values and wants to round symmetrically, to next integer or truncate, respectively. They're all available since 2003 version at least.
Regards!
