Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count days in between or if not entered till TODAY
Hello:
I'm trying to count days between two columns, it works fine till the "Current" column doesn't have an entry bcs an item hasn't been completed. In that case I want to count the days till "TODAY" since its still counting...any help? Do I need to use an IF with "Error" to accomplish this? i.e. Original Date Current/Completion Date 06/08/09 08/17/09 09/03/09 - 04/23/08 02/08/09 Simple formula works if both columns are populated but in a case like the row two above when the current day is not populated yet I'm getting error. Please help. Thank you. Monika |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates count till elapsed | Excel Discussion (Misc queries) | |||
Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
Days in a month as of today | Excel Worksheet Functions | |||
Can I count down days till an event? | Excel Discussion (Misc queries) | |||
Formula to count number of days in range which are less than today | Excel Worksheet Functions |