Date range counted in days in new column

**boxermack** · 02-05-2013, 05:52 PM

Hello,

I was wondering if I have a column with a set date range, such as this 05/20/2013 - 05/24/2013.

Is there a formula that can interpret that and post to another column how many days? Simply giving a number of 5 for the date range.

I would appreciate if you could give an example of how to do that. Thank you!!

**Special-K** · 02-05-2013, 06:03 PM

If they are truly dates and not text just subtract 1 date from the other and add 1

=(A2-A1)+1

where A1 and A2 are dates

**Tony Valko** · 02-05-2013, 06:09 PM

I'm asssuming you mean this is all in a single cell:

05/20/2013 - 05/24/2013

If so, try this:

=MID(A2,FIND("-",A2)+2,10)-LEFT(A2,FIND("-",A2)-2)+1

**boxermack** · 02-06-2013, 10:06 AM

Thank you so much! Tony, that formula worked great! Exactly what I needed.

I love this forum!

**boxermack** · 02-06-2013, 12:42 PM

I have one follow up question, can there be something added to that stating, that if >5 (days) then it will say NA or ERROR or whatever I would like it to say?