View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mac56er mac56er is offline
external usenet poster
 
Posts: 2
Default 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?