days of month

  1. A

    Calculate the dates for a specific month where multiple In and Out dates are present

    Hi Team, Is there a formula which can get the total number of days between multiple entry and exit days in the same month. I have 6 columns in total and 3 of those are Entry dates and the other 3 are exit dates. Its not mandatory that the entry dates are to be filled nor the exit dates. SO if...
  2. H

    How many mondays, tuesdays, etc in a month

    Dear all, A new challenge! Can somebody help me with the vba code or formulas for extracting the number of mondays, tuesdays, etc from a specific month in a specific year? i need this information for calculating the amount of delivery days for our clients. Thanks in advance. Regards from...
  3. T

    Week Number

    I have an excel sheet for paychecks for total hours and i use the weeknumber function to total up paychecks that i should be getting and compare with actual, however the weeknum function that i use i can only get to start on monday or sunday, but i need the week to start over on friday how do i...
  4. C

    Day of Week between dates

    I am trying to determine how many times a given day of week is in a given date range (as below). Does anybody have an idea of a formula that I could insert into the Sunday, Monday, etc. columns? <TABLE style="WIDTH: 583pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=776...
  5. P

    Excel 2007 form problem, Dates

    Hi I am trying to make a spreadsheet such that i have a spinner tool at the top of the page, and when all the days of the month in the form dd/mm/yyyy are displayed, and when i click the down arrow it goes to next month so the mm bit of the days changed and no. of days change automatically...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top