calculate pre-assigned days per month from a file, which works on a daily basis and collects figures over an interface

TonyPro

New Member
Joined
Nov 20, 2017
Messages
1
I am looking for a working formula to calculate the number of days a shop is open. Opening days are usually Wed til Sat, but shop could be open any day, according to business needs. Formula need to be embedded in a excel workbook, which is collecting information's through interface. Workbook has to be re-run once every day. Formula should be self sufficient and zero or at least as little as possible, manual input is necessary. Workbook works with amount of days/month, day of week and date, time not necessary.

I cant supply any formula because I haven't found anything which I'd need as of yet.

Thanks for helping,
TP
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,099,064
Messages
5,466,380
Members
406,478
Latest member
Amar kumar

This Week's Hot Topics

Top