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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating total number of days
Have you tried to nest the formula with an if statement? Where you would say
=if(a1=b1,1,if(isblank(b1),0,day(b1-a1))) "mac56er" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating total number of days
Hi
In order to include the whole of the start day and the whole of the end day in any calculation, you need to use =enddate-startdate+1 With startdate in A1 and enddate in B1 Try =IF(COUNT(A1:B1)<2,"",B1-A1+1) -- Regards Roger Govier "mac56er" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating total number of days
Roger,
Thanks! It worked. Van Matthews "Roger Govier" wrote: Hi In order to include the whole of the start day and the whole of the end day in any calculation, you need to use =enddate-startdate+1 With startdate in A1 and enddate in B1 Try =IF(COUNT(A1:B1)<2,"",B1-A1+1) -- Regards Roger Govier "mac56er" wrote in message ... 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? |
Reply |
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 |