LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default Day Counting - OPEN & CLOSED

I have three columns:
A=Start Date
B=End Date
C=Days

I'd like to count days if there is or is not an end date. So if the start
date was two weeks ago but there is no end date, I'd like the Days.column to
continue to increase as the days go by but end on the date entered into the
End.date column.

Seems easy but it's the easy things that elude me sometimes. Can someone
please help me with a formula for that?

Thanks in advance!!!
Dax
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
reference a closed filed from a cell and formula in an open file dh13134 Excel Worksheet Functions 15 August 6th 08 08:08 PM
Move entire row of data from open to closed file by entering date TB[_2_] Excel Discussion (Misc queries) 0 May 12th 08 10:07 PM
Counting Days Open Roy Excel Discussion (Misc queries) 2 May 2nd 07 10:19 PM
Show blank cell when not Closed or Open roy.okinawa Excel Worksheet Functions 4 December 8th 05 01:18 AM
VBAProject remains open after file is closed sequoia sam Excel Discussion (Misc queries) 4 August 2nd 05 07:59 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"