Microsoft Excel - Date projections
Asked By karen
07-Sep-10 10:10 AM
I need a formula to project a date based on number of workdays. Example: Today (9/7/2010) + 21 workdays=10/6/2010. I am looking for the formula that return the 10/6/2010 answer. Thanks.
Venkat K replied to karen
You need to do nothing for this:
Assume you have dates in Column A,
set both the columns (A,B and also the result Column C formats as Date):
A B
Date Days to add
6/9/2007 3
=TODAY() 5
12/10/2008 54
Copy the below formula in column C then the result will be automatically shown in Column C:
| Formula |
Description (Result) |
| =A2+B2 |
Add 3 days to 6/9/2007 (6/12/2007) |
| =A3+B3 |
Add 5 days to the current day (varies) |
| =A4+B4 |
Add 54 days to 12/10/2008 (2/2/2009) |
Thanks
karen replied to Venkat K
I understand your answer; however, my calculation should include weekdays only--not weekends. So that if I need to add 4 weekdays (workdays) to 9/7/2010, the answer I am looking for would be Monday, 9/13/2010 not Saturday 9/11/2010.
karen replied to Venkat K
I am still getting weekends in the calculations--see below.
| Start |
Add |
End |
| 9/7/2010 |
4 |
9/11/2010 |
| 9/7/2010 |
5 |
9/12/2010 |
Note that 9/11 is a Saturday and 9/12 is a Sunday.
I was expecting the first calculation to return 9/13/2010 (Monday) and the second calculation to return 9/14/2010 (Tuesday).
What is the default alignment for values in Excel? Excel Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Bliengme (1) Caps (1) Text (and Boolean TRUE / FALSE) to left; numbers (including date) to right - - Bernard V Liengme Microsoft Excel MVP www.stfx.ca / people / bliengme remove caps from email Right-aligned for numerics
Date Issue with Microsoft Excel Excel I have a csv file that I open with MS Excel. It contains a date within it in the format m / d / yy (e.g. 6 / 7 / 36). The date is meant to be 2036 but Excel translates the date to 1936. My Regional settings in the Control Panel are set up
Date not displaying correctly Excel Microsoft Excel 2007 I have a column whose fields are defined as 'date'. When I type the date into the field it will not display the correct date. Example: I type in '9 / 29 / 08' and the field displays '1-Jan-00' instead reads what i typed. . .' = 9 / 29 / 08' Any suggestions as to why this is happening?? Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) Excel 2003 (1) Office (1) TYPE (1
I need help please. I am creating a staff scheduling. the format is like this date date date date date date name client A client A client C client C client D client D name client create a summary per client which showing the staff participated in each client and the date we perform work on the client. I am thinking to use Vlookup function. To do table which copy the name column between each column which make the table like this date name date name date name client A name client A name client C name client
Does anyone have a template for creating a slip chart in Excel Excel Excel Charting Discussions Microsoft Excel (1) Series (1) Chart (1) Excel (1) ChartsHowTo (1) Accidents (1) Crosses (1) Plots (1) Hi, Can you provide a link to an example of what you mean by 'Slip Chart'? Cheers Andy - - Andy Pope, Microsoft MVP - Excel http: / / www.andypope.info I assume he means this: http: / / www.noweco.com / qei / qeie10