View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BBD BBD is offline
external usenet poster
 
Posts: 2
Default If then between two dates

I am trying to distribute revenue evenly between two dates. I have in one
cell the beginning of the project. I have in another cell the end of the
project. One my spreadsheet, I am referencing the month to determine if it
falls betwen the project dates. I thought it was an if(and statement but it
doesn't return the answer. Any suggestions would be greatly appreciated.