Find end date based on start date and number of weeks c#.net...

Question

1.00/5 (2 votes)

See more:

hi friends,

I am using gridview in that I have one bound field and 3 textbox template fields like this

------------------------------------------------------------- ---------
phase      Duration(weeks)    SrartDate         EndDate 
 
-----------------------------------------------------------------------

out side of gridview I have field: working days in a week:
ex: 5 0r 6

If I enter 1 or 1.5 week in Duration textbox , start Date : 12-05-2017 and if total working days in a week: 5 based on this values remove sturdays and sundays and find and display
End Date in gridview.

if working days in a week 6 days remove only sundays and find EndDate and display it in gridview.

Example:
If we Consider duration as 1 week,Working days in a week 6

then after 12-05-2017 then remove sunday date from calculation and the final End Date should print

20-05-2017

how to achive this??

What I have tried:

I tried using Adddays Method to given date

Posted 5-May-17 1:05am

prasanna204

Updated 5-May-17 2:36am

CHill60

v2

Add a Solution

Comments

Richard MacCutchan 5-May-17 7:29am

So what is the problem?

prasanna204 5-May-17 7:31am

how to get the end date based on mentioned scenarios?I need code help

Richard MacCutchan 5-May-17 7:49am

Add the number of days to the start date.

[no name] 5-May-17 7:33am

what have you tried? Update question by adding your code/scripts...

prasanna204 5-May-17 8:08am

Duration(weeks)=1;nofofworkingdays(in a week)=5;
Datetime Dt=convert.Todatedime(txtStartDate.Text);
Date date=dt.AddDays(7);
how to exclude saturdays and sundays if any caluculate based on nofofworking days

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2017-05-05T02:36:00

Add the number of days and check the week day afterwards (add one or two days for Sunday and Saturday):

C#

// Add number of days
dt.AddDays(weeks * 7);
// Choose Monday if end date is Sunday
if (dt.DayOfWeek == DayOfWeek.Sunday)
    dt.AddDays(1);
// Choose Monday if end date is Saturday and Saturday is not a working day
else if (workingDays < 6 && dt.DayOfWeek == DayOfWeek.Saturday)
    dt.AddDays(2);