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]

Try =IF(C2="","",C2+(20*7))

 

[jayjaysb]

Hi Chris, Can't get it to work, Thanks JJSB

 

[Chris Macro]

It's working on my end. Here are my formulas for row3:

Excel 2007
	A	B	C	D	E	F	G
1		Tgt Date	Date	Plus 20 Wks	Target Meet?	Birth Date	Age
2	Data	4/25/2014	1/1/2014	5/21/2014	Yes	1/1/1980	34
3						1/2/1972	42
4	Formula			=IF(C3="","",C3+(20*7))	=IF(D3="","",IF(B3<=D3,"Yes","No"))		ROUNDDOWN((TODAY()-F3)/365.25,0)
Sheet3

 

[jayjaysb]

Brilliant Chris, Much obliged for all your help

 

[Chris Macro]

No problem, glad I could help!

 

[jayjaysb]

Chris, One last thing if you dont mind, could you modify ROUNDDOWN((TODAY()-F3)/365.25,0) and =IF(D3="","",IF(B3<=D3,"Yes","No")) so they do the same with the blanks. Thanks JJSB

 

[Chris Macro]

=IF(ISBLANK(F3),"",ROUNDDOWN((TODAY()-F3)/365.25,0))

In what situation(s) do you want the second formula to be blank?

 

[jayjaysb]

Excellent Chris, well pleased with your help, When I copy down the cell of the =IF(D3="","",IF(B3<=D3,"Yes","No")) it's showing Yeses even though the other cells don't have dates in them. Thanks JJSB

 

[Chris Macro]

Maybe try: =IF(OR(B3="",D3=""),"",IF(B3<=D3,"Yes","No"))

 

[jayjaysb]

Oh my sweet mother, bang on the money!!! Thanks for all your help Chris, Have a good weekend, Cheers JJSB