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

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

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