Calculation Date, need help

[NewbieHere]

Hello all,

I have a field called PickUp date. It is in the form of a radio button set (Monday, Tuesday etc..). Now here's my problem. For example if today is Tuesday Febuary 12 2005, and a customer comes and ask's if he/she could pick up their order on Friday. All I would have to do is Check off Friday in my Radio boxes, and in another field get Friday Febuary 15 2005.

 

Is this possible, if so ho?

Thanxs a bunch

[comment]

Try:

 

cPickUpDate (calculation, result is Date) =

 

Let ( [

today = Get ( CurrentDate ) ;

start = today - DayofWeek ( today ) ;

pickday = ( Position ( "SuMoTuWeThFrSa" ; Left ( PickUp ; 2 ) ; 1 ; 1 ) + 1 ) / 2 ;

add = pickday

] ;

start + pickday + 7 * add

)