Menu

Conditional Difference between two dates

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.misc

Dougal

Dougal is offline

external usenet poster

Posts: 4

Default

Conditional Difference between two dates

wrote:
I have a sheet in which two column are the start date and the end date.
All of the records contain a start date but not all contain an ending
date. How do I, in a third column calculate the difference between the
end date and start date (only if there is an end date present), to give
me the total days or a null if the end date is not present. Also how
do I copy that formula to all the cells in the column????

Hi,

You can use a formula like this:

=IF(B1<"",B1-A1)

Dom

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
formula to obtain difference between two dates.	Onkar Raut	Excel Worksheet Functions	2	June 19th 06 08:36 AM
Help with Conditional Formatting (Dates)	BigH	Excel Discussion (Misc queries)	1	January 28th 06 10:47 PM
Difference in dates calculations except between certain times.	Steve Hud	Excel Discussion (Misc queries)	1	January 13th 06 01:10 PM
How do I create conditional formatting to track due dates	Soraiya	Excel Worksheet Functions	2	October 14th 05 03:26 PM
compute the difference between two dates accurately	Dilly	Excel Discussion (Misc queries)	6	April 30th 05 02:18 PM

All times are GMT +1. The time now is 10:01 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement