| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating total number of days
I need to calculate the total number of days for a project. The spreadsheet
is set up to calculate the number of days for each month and then sum the total of days. However, I cannot figure out the formula to calculate when the beginning and end date is the same. For example, the projects ends on 1 Jun 08. The total number of days for June needs to be 1. Also, if a month has no dates, the result should be 0. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating number of days between first day to last day, inclusiv | Excel Worksheet Functions | |||
| Calculating Number of days from one date to another | Excel Discussion (Misc queries) | |||
| Calculating number of hours between two days | Excel Worksheet Functions | |||
| Calculating the number of days worked | Excel Worksheet Functions | |||
| Calculating number of days | Excel Worksheet Functions | |||
Threaded Mode
