Find Friday with CALCDATE

cure

hello everybody, may you help me?

I have to find the date for Friday in a week by using the following Code.

"Posting Date" + CalcFormula (f.e. 2W) = NewDate (It have to be Friday in 2 weeks!)

It's possible to do this with CalcDate? Do I need another Function? :?:

Thanks for helping me

curdin pfister
zuerich, switzerland

Arhontis

Hi,

Have you tried the:

CALCDATE('+2W+WD4',TODAY)

Arhontis

oops WD5 is friday not WD4,sorry:

CALCDATE('+2W+WD5',TODAY)

cure

Hello, thank you for your help, it works fine.

Have nice day

curdin