Counting special REPORT Dates

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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
 
Hi Chris,

Pl enter following formula in cell c1

=MID(B1,3,4)-MID(A1,3,4)

H S Shastri

==========================================================
 
Thanks
working perfect

HARSHAWARDHAN. S .SHASTRI said:
Hi Chris,

Pl enter following formula in cell c1

=MID(B1,3,4)-MID(A1,3,4)

H S Shastri

==========================================================
Click to expand...
 
Back
Top