|
date problem
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! |
date problem
=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! |
date problem
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! |
date problem
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! |
date problem
Hi, works great.
Thanks1 But how to add to a date exactly 5 years? Thanks! "Jacob Skaria" wrote: 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! |
date problem
Try
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) -- Jacob "puiuluipui" wrote: Hi, works great. Thanks1 But how to add to a date exactly 5 years? Thanks! "Jacob Skaria" wrote: 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! |
date problem
Perfect!
Thanks! "Jacob Skaria" wrote: Try =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1)) -- Jacob "puiuluipui" wrote: Hi, works great. Thanks1 But how to add to a date exactly 5 years? Thanks! "Jacob Skaria" wrote: 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! |
| All times are GMT +1. The time now is 04:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com