| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date minus date=No. of days?
Hi folks, Apologies if my answer is here but I can't find it. I have a task list and I need to record how many days since task allocated. So it's: today - date allocated=135(days) 0r 03/03/2006-11/12/2005=82(days) Many thanks in advance, Scoville -- Scoville ------------------------------------------------------------------------ Scoville's Profile: http://www.excelforum.com/member.php...o&userid=32088 View this thread: http://www.excelforum.com/showthread...hreadid=518425 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date minus date=No. of days?
If cell A1 is today and cell B1 is the date allocated, in cell C, which is
formatted as a number, type = A1-B1. If you need to include today, use =A1-B1+1. "Scoville" wrote: Hi folks, Apologies if my answer is here but I can't find it. I have a task list and I need to record how many days since task allocated. So it's: today - date allocated=135(days) 0r 03/03/2006-11/12/2005=82(days) Many thanks in advance, Scoville -- Scoville ------------------------------------------------------------------------ Scoville's Profile: http://www.excelforum.com/member.php...o&userid=32088 View this thread: http://www.excelforum.com/showthread...hreadid=518425 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date minus date=No. of days?
=TODAY()-A1
where A1 is the date allocated -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Scoville" wrote in message ... Hi folks, Apologies if my answer is here but I can't find it. I have a task list and I need to record how many days since task allocated. So it's: today - date allocated=135(days) 0r 03/03/2006-11/12/2005=82(days) Many thanks in advance, Scoville -- Scoville ------------------------------------------------------------------------ Scoville's Profile: http://www.excelforum.com/member.php...o&userid=32088 View this thread: http://www.excelforum.com/showthread...hreadid=518425 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel,how do I change the date to a date 84 days from previous | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| set a date in columns 7 days apart | Excel Worksheet Functions | |||
| Excel running date formula minus weekend days | Excel Worksheet Functions | |||
| business days between 2 date feilds | Excel Worksheet Functions | |||
Hybrid Mode
