creation of excel report with new requirement

Please see attachment. My yesterday's requirement was fulfilled for creation of report. My new requirement is to have report on yesterday's date. Whenever i will create report it should give me details of yesterday transactions (exchange of documents done through folders : From Reliance, Reject and To Reliance). Currently i am having details of all dates. Can you please help. Thanks & Regards,

Just an idea, what if you add this statement in your countifs on Sheet1:

1. If you want a report on everything before today: Sheet2!C:C;<(Today()-1)
2. If you want a report on only yesterday: Sheet2!C:C;(Today()-1)

Where Sheet2!C:C is the date range.

It wasn't that easy, your date format is not matching the format of the formula TODAY(), also the time stamps messes things up. If you somehow could change the date in your C-column, or add a cell with TODAY() that you can change to match your date format. Maybe someone better at this can help with that?

ok i can help you with my ways...i will up my video what i do. Waiting for me. Thanks

Originally Posted by Javed Ali Sayed

Please see attachment. My yesterday's requirement was fulfilled for creation of report. My new requirement is to have report on yesterday's date. Whenever i will create report it should give me details of yesterday transactions (exchange of documents done through folders : From Reliance, Reject and To Reliance). Currently i am having details of all dates. Can you please help. Thanks & Regards,

Hello.
i don't up video in forum because my skype is sonktpm2. I will send link youtube for you if you want, i have done your math by my way. It is perfect and i think you will like it.

Please send youtube. Thanks a lot. Best Regards,

Originally Posted by Javed Ali Sayed

Please send youtube. Thanks a lot. Best Regards,

Hello
Sorry about my delay. I sent you link youtube. You can check message.
I think and hope i will help you. I use add-in a-tools to do reports.
Thanks.
Sorry agains.