Excel- Add values between two dates

Closed
Em - Feb 17, 2011 at 08:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2011 at 08:45 AM
I have a spreadsheet on Excel in which there are dates of when contractors invoiced us and when they were paid. I need to work out the total days invoiced for each person paid in say Jan but they are all of different dates and there are 15 different contractors all being paid different amounts and working different numbers of hours. Is there a quick way to do this?

Thanks
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2011 at 08:45 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0