Search results

thanks for that dee

Private Sub Command7_Click() 'Enddate is a textbox 'Numofdays is a textbox 'Newdat is a textbox(displays results) Dim intCount As Integer Dim Myenddate As Date Dim Tempdate As Date intCount = 0 EndDate.SetFocus Myenddate = EndDate.Text NumOfDays.SetFocus Tempdate = EndDate.Value Do Until...

i have got this: Private Sub Command7_Click() 'Enddate is a textbox 'Numofdays is a textbox 'Newdat is a textbox(displays results) Dim intCount As Integer Dim Myenddate As Date Dim Tempdate As Date intCount = 0 EndDate.SetFocus Myenddate = EndDate.Text NumOfDays.SetFocus Tempdate =...

basically what i've done so far is, i've worked out the date difference between to dates which give me x working days, now i want to add the x working days to my end date but it can't include weekend as the business is closed over the weekend. hope this helps dee

Ok, if the 05/09/07 is today(wednesday) and if i add 5 working days then the date should be 12/09/07 (wednesday) thanks

that didn't work mate, the result showed as 10/09/2007

ok, so for example if the date is 05/08/07 and we add 5 days then the new date should be 12/08/07

but i want it to exclude the Saturday and Sunday??

Can someone please help me...what i want to do is get today's date and add 5 working day to it and display the new date in a text box. eg 05/08/07 + 5 should have a new date of 12/08/07. thanks dee