If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Display the days between start & end date columns
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Display the days between start & end date columns

#1
May 18th 10, 05:30 PM posted to microsoft.public.excel.misc
 Pat Briggs external usenet poster Posts: 1
Display the days between start & end date columns

I have two columns one labeled start date, the other Date Completed. I have
a third column where I need to display how many days it took to complete the
process from start to finish. Do I need a macro? I have no idea how to
format the third column to calculate the days between the other two.
#2
May 18th 10, 05:36 PM posted to microsoft.public.excel.misc
 Mike H external usenet poster Posts: 11,504
Display the days between start & end date columns

Hi,

Try this un-documented formula

=DATEDIF(A1,B1,"d")

For help on this formula look here

http://www.cpearson.com/excel/datedif.aspx
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Pat Briggs" wrote:

> I have two columns one labeled start date, the other Date Completed. I have
> a third column where I need to display how many days it took to complete the
> process from start to finish. Do I need a macro? I have no idea how to
> format the third column to calculate the days between the other two.

#3
May 18th 10, 05:37 PM posted to microsoft.public.excel.misc
 MS-Exl-Learner external usenet poster Posts: 132
Display the days between start & end date columns

Assume that in A2 cell you are having the START DATE and in B2 cell is the
END DATE.

Copy and paste the below formula in C2 cell
=IF(AND(A2<>"",B2<>""),DATEDIF(A2,B2,"D"),"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Pat Briggs" wrote:

> I have two columns one labeled start date, the other Date Completed. I have
> a third column where I need to display how many days it took to complete the
> process from start to finish. Do I need a macro? I have no idea how to
> format the third column to calculate the days between the other two.

#4
May 18th 10, 05:45 PM posted to microsoft.public.excel.misc
 T. Valko external usenet poster Posts: 15,768
Display the days between start & end date columns

Just subtract the start date from the end date.

A1 = start date = 1/1/2010
B1 = end date = 1/31/2010

=B1-A1

Format as General or Number

Result = 30

Copy down as needed.

--
Biff
Microsoft Excel MVP

"Pat Briggs" > wrote in message
...
>I have two columns one labeled start date, the other Date Completed. I
>have
> a third column where I need to display how many days it took to complete
> the
> process from start to finish. Do I need a macro? I have no idea how to
> format the third column to calculate the days between the other two.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Calculate 60 days from Start Date - including weekends Missy Excel Worksheet Functions 5 August 19th 09 04:27 PM Count Number of Days after a Start Date Jimbo Excel Discussion (Misc queries) 4 May 6th 09 09:17 PM Calculating number of days including the start and end date Shane Devenshire[_2_] Excel Discussion (Misc queries) 0 February 26th 09 10:45 PM find and display all possible start times and days to work Shoney Excel Discussion (Misc queries) 0 February 8th 08 08:07 PM I want to count days between two dates including start date Infinitebiscuit Excel Worksheet Functions 2 February 20th 07 12:27 PM

All times are GMT +1. The time now is 02:40 PM.