Menu

Extract date from cell

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Ron Rosenfeld

Posts: n/a

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date format within a cell containing a formula	Brushie76	Excel Discussion (Misc queries)	1	January 22nd 05 03:50 AM
Formula with text and reference to a date cell	[email protected]	Excel Discussion (Misc queries)	1	January 11th 05 08:15 AM
How would I change a date cell to decrease it by business days?	CNGracin	Excel Discussion (Misc queries)	3	December 15th 04 05:20 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Combined date time cell to separate date & time components	Mark Ada	Excel Discussion (Misc queries)	1	December 2nd 04 02:48 AM

All times are GMT +1. The time now is 05:39 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement