-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
specified date
-
I
Is this impossible?
People always ask 'can i add x amount of days to a date excluding weekends/holidays?' I want to know; Can I add x amount of days to a date, excluding specific days of the week i.e mondays and tuesdays? So if I want to add 20 days to a date but not count mondays or tuesdays? Is that possible...- intheskywithdiamonds
- Thread
- add days days of week excel specified date working pattern
- Replies: 11
- Forum: Excel Questions
-
K
Counting occurrences in a specified range and date
I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error")) ... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type). Instead of finding the sum of the 'Quantity', can...- kebabpete
- Thread
- counting occurences specific date specified date
- Replies: 5
- Forum: Excel Questions
-
P
Searching For Files on Drive and Excluding Certain Files
I'm searching for certain files on a specified, referenced drive in Worksheet("Parameters"). These files have to be last modified before a certain date and the search should not locate certain files in specified, referenced folders. The goal of this project is to collect "stale files," and...- pawest
- Thread
- excel 2003 if then list files select files specified date
- Replies: 2
- Forum: Excel Questions
