Date Trim Formula

**AznDragon533** · 12-02-2011, 03:27 PM

Hello,

I just have a small problem, please help,

I have a cell: "6/2/2011 - 8/2/2011"

Current Date: Today date 11/2/2011

and then another cell :Days Outstanding:

I would like to take Today date and subtract it to 8/2/2011 , that would give me how many days has passed.

please help (attachment)

**Haseeb Avarakkan** · 12-02-2011, 03:33 PM

Try any of these,

In H2 enter =TODAY()

G6, copy down.

=H$2-LOOKUP(9E300,RIGHT(F6,{8,9,10})+0)

Or,

=H$2-RIGHT(F6,LEN(F6)-FIND("-",F6))

**AznDragon533** · 12-02-2011, 03:54 PM

Originally Posted by Haseeb A

Try any of these,

In H2 enter =TODAY()

G6, copy down.

=H$2-LOOKUP(9E300,RIGHT(F6,{8,9,10})+0)

Or,

=H$2-RIGHT(F6,LEN(F6)-FIND("-",F6))

perfect, thanks!

**arthurbr** · 12-02-2011, 03:55 PM

Don't quote whole posts -- it's just clutter.

If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.