| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate days between dates
Theres a problem I came across: I would like to add the days between two cells e.g: A B 03/12/2006 03/20/2006 I want the total number of days that I took to complete my task i.e 9days How do I get this 9days..what is the formula.... Someone Plzz help !!!! -- sunita_shaw ------------------------------------------------------------------------ sunita_shaw's Profile: http://www.excelforum.com/member.php...o&userid=32227 View this thread: http://www.excelforum.com/showthread...hreadid=519764 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days between dates
In C1, =B1-A1+1 Format the cell of your result as General or Number to 0 decimal places. HTH, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=519764 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days between dates
One way:
=B1-A1+1 Format as General or Number. In article , sunita_shaw wrote: Theres a problem I came across: I would like to add the days between two cells e.g: A B 03/12/2006 03/20/2006 I want the total number of days that I took to complete my task i.e 9days How do I get this 9days..what is the formula.... Someone Plzz help !!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days between dates
Hi! Steve , I tried but my dates get formated into plain numbers and when I try doing it some other sheet too I get the difference in the form of dates... -- sunita_shaw ------------------------------------------------------------------------ sunita_shaw's Profile: http://www.excelforum.com/member.php...o&userid=32227 View this thread: http://www.excelforum.com/showthread...hreadid=519764 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate days between dates
Sunita, Keep the cells where your dates are formatted as dates. Only change the format of the cell that you input the formula into to a number to return only a number. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=519764 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
| calculate with dates before 1-1-1900 | Excel Worksheet Functions | |||
Linear Mode
