Need a bit of help with some date functions. I have a project that needs to do two different calc's to figure either the period end date or the total number of weeks between two dates. I'm trying to write two different public sub's in a global bas as I need to be able to call them both from various different forms within the project.

The first has to work out the end date by adding on the number of weeks entered(txt field) to the start date(maskEdBox). I can't get the DateADD function to work properly.

The other has to work out the number of weeks between the dates entered(both maskEDBox's). Again I have a problem with DateDiff function.

Anyone's whose done this sort of thing before I'd appreciate any help, It looks like it should be simple enough.....which doesn't say a lot for me!!

Thanx in advance
Gin