dates in a list

<tbody> Ref Company Date Company INV Number Sub Total Expenses Difference Grand Total Paid Credit Status Date Sum Outstanding Amount Sum by Date 1 Test 2018/10/03 Test 2018/10/03_Test0001 Test0001 R3 888,00 R2 110,00 -R 4 002,00 R 5 998,00 Yes OPEN -R 4 002,00 0,00 43377 43376 2 test...

I have a workbook to chart assignments given to 30 or so subcontractors. Each contractor has a tab within the book. The table in each tab the following column headers: Lease #, Date Ordered, Date Due, Date Received. I'd like an index page that shows a column with each of the contractors name...

Hi friends, New here and really hope someone can help. This is for a work challenge so is super important to me. I have never created a macro in excel, though I'm almost positive this is the only way to get excel to perform the task. In my workbook I have price data for a stock by day (I am...

Hi all. I normally get paid on the 15th of every month, though sometimes this could be later. If I enter the actual payment dates in A1:A12, which formula can I use to count the number of times they were made late?

Hello Again, I was looking for some help to determine if any of the dates listed cells A6 through A17 is equal to (A1); or if they fall between A1 and A2). Placing a result in A3. Example A1: Mar 15-13 A2: Mar 29-13 A3: "Yes" (result or "no" depending on result) A6: January-29-13 A7...