Counting special REPORT Dates

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
 
H

HARSHAWARDHAN. S .SHASTRI

Hi Chris,

Pl enter following formula in cell c1

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

H S Shastri

==========================================================
 
C

Chris

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
Calculate elapsed time excluding specific timeframe 10
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
If, And Or 2
Generating a Julian date, but only showing the last two numbers 9
converting julian day and year to a date? 1
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Need Help 4

Top