| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date problem | New Users to Excel | |||
| Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
| Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
| Date problem | Excel Discussion (Misc queries) | |||
| 'Date' problem | Excel Discussion (Misc queries) | |||
Linear Mode
