Excel formula for calculation of weeks required.?

Question

Normally DATEDIF formula is applied for calculation of Days and Months between two dates.

For example if one wanna know what will be the date if two weeks are added in todays date i.e. March 1, 2008 two weeks will end on March 14, 2008. But how to arrive at this date by applying a formula.

Will somebody tell me about calculation of weeks formula, pls.

Answer 1

To add two weeks, simply add the number of days. If today is March 1, this will give the result March 15.



=TODAY() + 14



Since you want the result to be March 14, change this to:



=TODAY() + 13



I hope that helps, but add more detail, or e-mail, if you need more info.

Good luck!

.

Answer 2

Two weeks from March 1 is March 15 (a Saturday), but you seem to want the 14th, which is a Friday. Are you trying to calculate two work weeks, or two actual weeks?



Two actual weeks can be achieved by just adding 14 to the date:



=A1+14



If, instead, you want to add two work weeks to a date, you can use the Workday() function:



=WORKDAY(A1,10)



Note that I'm assuming that your workweek is 5 days (Monday through Friday), so instead of adding 14 days, it only adds 10 working days. The Workday() function also allows you to specify a list of holidays so that it can exclude them from the result.



Note that the Workday() function is a part of the Analysis ToolPak add-in in Excel 2003 and earlier (it is a regular function in Excel 2007). If you can't find the function, go to Tools --> Add-ins and enable Analysis ToolPak.



Tim

http://feeds.feedburner.com/ExcelBlog

Answer 3

SORRY IF I published a question TO I do exactly not understand the thank you to submit a question PLS help: the thank you to COMPUTE IN EXCEL? GIVEN: A1 = a million/15/14 B1 = 6/27/14. answer IN C1 could be form of MONTHS between the two DATES that's 5MONTHS THEN answer IN D1 could be THE form of WEEKS AFTER THE 5MONTHS that's 2WEEKS.