| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate the number of days between two dates?
If I have a start and stop date (inclusive) - how can I write a formula to
determine the total number of days? Assuming A1 is start date, B1 is end date and C1=total days (inclusive). This would be a big help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate the number of days between two dates?
Use =B1-A1+1 Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 24 Mar 2009 09:11:02 -0700, stumped-in-excel wrote: If I have a start and stop date (inclusive) - how can I write a formula to determine the total number of days? Assuming A1 is start date, B1 is end date and C1=total days (inclusive). This would be a big help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate the number of days between two dates?
You probably want this...
=B1-A1+1 -- Rick (MVP - Excel) "stumped-in-excel" wrote in message ... If I have a start and stop date (inclusive) - how can I write a formula to determine the total number of days? Assuming A1 is start date, B1 is end date and C1=total days (inclusive). This would be a big help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i calculate the number of days between two dates?
C1=B1-A1+1 and format cells to number
"stumped-in-excel" wrote: If I have a start and stop date (inclusive) - how can I write a formula to determine the total number of days? Assuming A1 is start date, B1 is end date and C1=total days (inclusive). This would be a big help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate the number of days between two dates | Excel Discussion (Misc queries) | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
![stumped-in-excel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
