| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting special REPORT Dates
Hi,
it might sounds easy for some of you specialists but ill need help on a Formula! In Column A1 i got the text A072610856 and in Column B1 the text B072681000. the digits out of the cell A1 "**7261*" equels the julian date as well as the digits "**7268*" out of cell B1. I need a formula witch takes only the julian date of cell B1 minus the julian date in cell A1 to find out about delay days. PS: Office 2003 Thanks Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting special REPORT Dates
Hi Chris,
Pl enter following formula in cell c1 =MID(B1,3,4)-MID(A1,3,4) H S Shastri ================================================== ======== "Chris" wrote: Hi, it might sounds easy for some of you specialists but ill need help on a Formula! In Column A1 i got the text A072610856 and in Column B1 the text B072681000. the digits out of the cell A1 "**7261*" equels the julian date as well as the digits "**7268*" out of cell B1. I need a formula witch takes only the julian date of cell B1 minus the julian date in cell A1 to find out about delay days. PS: Office 2003 Thanks Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting special REPORT Dates
Thanks
working perfect "HARSHAWARDHAN. S .SHASTRI" wrote: Hi Chris, Pl enter following formula in cell c1 =MID(B1,3,4)-MID(A1,3,4) H S Shastri ================================================== ======== "Chris" wrote: Hi, it might sounds easy for some of you specialists but ill need help on a Formula! In Column A1 i got the text A072610856 and in Column B1 the text B072681000. the digits out of the cell A1 "**7261*" equels the julian date as well as the digits "**7268*" out of cell B1. I need a formula witch takes only the julian date of cell B1 minus the julian date in cell A1 to find out about delay days. PS: Office 2003 Thanks Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and special functions in Pivot table report | Excel Worksheet Functions | |||
| Report on upcoming dates | Excel Discussion (Misc queries) | |||
| counting occasions dates occur between 2 dates | New Users to Excel | |||
| Counting cells if special criterias are true | Excel Worksheet Functions | |||
| Paste Special With Dates And Links | About this forum | |||
Linear Mode
