Dates Plus 20

[jayjaysb]

Hi all,

Looking for some help. Column C will contain a date, I am looking for Column D to auto add 20 weeks.

Also based on this I want column E to show a yes no if the target has been reached within the 20 wks or not.

One last request if you please in Column F I will have Date of Birth, could you give me a formula for Column G that will auto show the age.

Thanks in advance

JJSB

 

[Chris Macro]

haha, thanks!