Thread
:
Extract date from cell
View Single Post
#
4
Ron Rosenfeld
Posts: n/a
On 4 Nov 2004 06:28:26 -0800,
(Eric) wrote:
Could you explain how that formula works?
=(MID(A2,1+FIND(" ",A2),255))-A1
For the MID argument, look in HELP. 255 is just some large number, felt to be
larger than the probable length of your text in A2.
The FIND function looks for the location of the <space, and one is added to it
so the start of the string extracted by MID will not include that space.
Once the date in A2 is extracted, the date in A1 is subtracted from that to
give the difference in days.
--ron
Reply With Quote