date problem
in [General]
|
Prev: Custom Sort order issue
Next: reduce excel file size
From: puiuluipui on 16 Mar 2010 06:17 Hi, i need to know what day and month is the below date. 161th day of 2008 i have many days like this. i need a formula or something. I need them in dd/mm/yyy format. Can this be done? Thanks!
From: Sweep on 16 Mar 2010 06:31 Does this work for you? =TEXT(DATE(2008,1,1)+161,"dd/mm/yyyy") -- Sweep ------------------------------------------------------------------------ Sweep's Profile: 1611 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=187861 http://www.thecodecage.com/forumz/chat.php
From: Stefi on 16 Mar 2010 06:38 =DATE(A1,1,1)+B1-1 where year is in A1 day No (161) is in B1 Format result cell as required! -- Regards! Stefi „puiuluipui” ezt írta: > Hi, i need to know what day and month is the below date. > > 161th day of 2008 > i have many days like this. i need a formula or something. > > I need them in dd/mm/yyy format. > Can this be done? > Thanks!
From: Jacob Skaria on 16 Mar 2010 06:43 A1 = 161 Try formula =DATE(2008,1,A1) -- Jacob "puiuluipui" wrote: > Hi, i need to know what day and month is the below date. > > 161th day of 2008 > i have many days like this. i need a formula or something. > > I need them in dd/mm/yyy format. > Can this be done? > Thanks!
From: puiuluipui on 16 Mar 2010 07:03
Hi, works great. Thanks1 But how to add to a date exactly 5 years? Thanks! "Stefi" wrote: > =DATE(A1,1,1)+B1-1 > where year is in A1 > day No (161) is in B1 > > Format result cell as required! > > -- > Regards! > Stefi > > > > „puiuluipui” ezt írta: > > > Hi, i need to know what day and month is the below date. > > > > 161th day of 2008 > > i have many days like this. i need a formula or something. > > > > I need them in dd/mm/yyy format. > > Can this be done? > > Thanks! |