Hi,

Am Tue, 26 Aug 2014 21:07:51 +0100 schrieb zomccoy:

Example: A baby is born on 8/20/2014 at 30 weeks 2 days. I need a
formula to show me that on today's date (8/26/2014) the baby is now 31
weeks 1 day old. I'd like it to display as 31 weeks 1 day or 31 1/7.

in A1: 8/20/2012
in A2: 30 weeks 2 days

Then try:
=INT((TODAY()-A1+LEFT(A2,FIND(" ",A2)-1)*7+MID(A2,FIND("weeks",A2)+6,1))/7)&" weeks "&MOD(TODAY()-A1+LEFT(A2,FIND(" ",A2)-1)*7+MID(A2,FIND("weeks",A2)+6,1),7)&" days"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional