VBA to add workdays to datetxtbox

[hairypocketman]

Hi,

I have a userform that captures dates and records them to another excel workbook so we can analyse the data. I have one last part to finalise; When a date is added to the "daterecievedtxtbox" I would like a formula to be offset to the end of the spreadsheet, that will take this date and add 3 working days to it. Then I can add in some formulas later to flag them when the date passes the 3 working days.

At the moment I have this:

Please Login or Register  to view this content.

which adds 3 days to this txtbox and writes it to the sheet that I have defined. I would like to know if there is a function that I can use to add 3 WORKING days to this, excluding saturday and sunday. If it isnt this easy I will post the rest of my code so its easier for you to understand

[hairypocketman]

Thanks in Advance

[hairypocketman]

or if there is a way to add a formula that will know which row it has added to and increment it? so I could add

Please Login or Register  to view this content.

but If I put in "F4" for example, it will take F4 each time, is there a way that excel will know what row it is being wrwitten to?

[Solus Rankin]

Posting an example workbook would aid in a solution, or at the least the code in its entirety.

[hairypocketman]

Complaints Logger.xls

I have attached the workbook, I would like to be able to offset a cell that adds in 3 working days to the daterecievedtxtbox, and 15 working days to the dateacknowtxtbox please....

or another workaround to this???


AWESOME-O