Dates Plus 20

J

jayjaysb

Board Regular
Joined
Nov 16, 2011
Messages
204
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
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Is this what you were going for?


Excel 2007
ABCDEFG
1Tgt DateDatePlus 20 WksTarget Meet?Birth DateAge
2Data4/25/20141/1/20145/21/2014Yes1/1/198034
3Formula=C2+(20*7)=IF(B2<=D2,"Yes","No")=YEAR(TODAY())-YEAR(F2)
Sheet3
 
Upvote 0
Hi Chris Marco, this is almost spot on, and thanks for all your help. I am looking for the age to be exact, you know someone born 13/Feb/12 is 2 years old, but someone born 14/Feb/12 would still show up as one year old, until the date arrives, Hope I am making sense. Thanks JJSB
 
Upvote 0
Hi Chris Macro, I think I've got it with =ROUNDDOWN((TODAY()-F2)/365.25,0) Cheers for all your help. JJSB
 
Upvote 0
Chris, you know the formula =ROUNDDOWN((TODAY()-F2)/365.25,0) is there an equivelant I could use for excel 03, this formula works on my home 2013 but not my works 03. Thanks JJSB
 
Upvote 0
Chris, you know on the formula =C2+(20*7) when I drag this column down it shows date 19/05/1900 in all of them , because the there is no date input in B columns, how do i get Column C to show nothing until a date in column is input to column B, Hope this makes sense

COL B - - - - - - - COL C
Date</SPAN>
Date + 20</SPAN>
01/10/2013</SPAN>
18/02/2014</SPAN>
19/05/1900</SPAN>
19/05/1900</SPAN>

<TBODY>
</TBODY>
</SPAN>
</SPAN>
</SPAN>
</SPAN>
</SPAN>
</SPAN>
</SPAN>

<TBODY>
</TBODY>
</SPAN>

<TBODY>
</TBODY>
 
Upvote 0
Hi All and Chris, you know on the formula =C2+(20*7) when I drag this column down it shows date 19/05/1900 in all of them , because the there is no date input in B column, how do i get Column C to show nothing until a date in column is input to column B, Hope this makes sense

COL B - - - - - - - COL C
Date</SPAN>Date + 20wks</SPAN>
01/10/2013</SPAN>18/02/2014</SPAN>
19/05/1900</SPAN>
19/05/1900</SPAN>

<TBODY>
</TBODY>

</SPAN>		</SPAN>
</SPAN></SPAN>
</SPAN>
</SPAN>
</SPAN>

<TBODY>
</TBODY>
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Conditional Formatting based on age range
2
Replies
17
Views
930
CMW
C
S
  • Question
Find exact name across multiple tabs & combine with data from the most recent tab?
Replies
0
Views
62
Sunshine8790
S
O
  • Solved
american/australian dates
Replies
6
Views
226
Alex Blakenburg
A
A
  • Question
Breaking up CSV files based on date into individual txt files
Replies
2
Views
226
anuradhagrewal
A
I
  • Question
Tracking vacation requests
Replies
9
Views
433
KRice
K

Forum statistics

Threads
1,214,813
Messages
6,121,706
Members
449,049
Latest member
THMarana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top