count days

Need some help to figure this out. It is basically the opposite of networkdays, my UDF will count how many days in a date range are weekend days and holidays. Public Function NonWorkDays(StartDate As Date, EndDate As Date) As Long Dim wb As Workbook Dim wsList As Worksheet Dim...

Hello, if I enter the year "2017" in cell A1, is there a way I can determine how many days are in that year with a formula in cell B1? I need it so that I can roll forward spreadsheets from one year to the next by just updating the cell that contains the year, so that all the formulas will...

Hi, I have an excel sheet that I want to do conditional formatting in. this sheet is a product of an export from some other software and is sent to me on a daily basis. in it are columns titled "today sales sec" and "today sales ter". I want to be able to see how many consecutive days I have had...

Hello, I'm an analyst for and airport. I would like to count number of days between the landings of different aircraft types (cargo aircraft or freighters). The data does not come in clean. My first column is dates. The following columns are aircraft types, but each day the same aircraft don't...

Hi guys, I'm currently working on a spreadsheet in Excel 2013 that will allow me to track invoices and when they are due. Is there a formula I can use that will generate an "invoice due date"? The information I have in the spreadsheet is as follows (E.G.): Invoice date, 12/11/2013...

Hi Experts, Your help is highly appreciated. My problem is , I have a date range 21-Feb-2013 till 07-Mar-2013 (Col C2, Col D2 respectively) which is holiday list for a person. I am trying to pull out the number of working days for that person in the month of Feb which should exclude weekends...

Hi, I have a metric that counts the number of days we have gone without specific types of issues occuring. I created a simple calculation: =(B9-DATE(YEAR(B9),1,0))-Incidents!C1 This takes the current number of days in the year and subtracts the number of issues we've experienced. What I...

I want to put a start date on the spreadsheet in column A and in the column next to it (column B), I want it to show how many days have past between the start date and today's date. Example: Column A Column B (Today's Date 7/12/11) 7/04/11 8 How...