Excel- Add values between two dates

Closed
Em - Feb 17, 2011 at 08:24 AM
rizvisa1
Posts
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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