+ Reply to Thread
Results 1 to 2 of 2

Calculate the number of weekends that I have worked

  1. #1
    Registered User
    Join Date
    09-07-2015
    Location
    Forshaga, Sweden
    MS-Off Ver
    swe 2010
    Posts
    1

    Calculate the number of weekends that I have worked

    I want to figure out how many weekends I've been working this year (time intervals, filters). How do you do that?
    *
    The database consists of: date, start time, end time and notation.
    *
    Have tried with Pivottable, but there can only figure out the date range different weekdays. Not weekends.
    To see if I worked a weekend requires that either or both Saturday and Sunday are written down.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Calculate the number of weekends that I have worked

    Hey Variaxman,

    Welcome to Excel Forum.

    Please share your sample file -> go to advance and do the attachment.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculate total hours worked between 2 date/time stamps ignoring weekends and holidays
    By drewship in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-01-2015, 09:59 AM
  2. Calculate number of days excluding holidays and weekends
    By david1987 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 08:17 AM
  3. Calculate number of days, excluding weekends and holidays
    By cloyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2012, 04:37 PM
  4. [SOLVED] Calculate end date with a number of days WITHOUT Weekends / Holidays
    By gaia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2012, 08:06 AM
  5. Calculate Hours Worked, Minus Weekends
    By Violator in forum Excel General
    Replies: 13
    Last Post: 11-15-2009, 05:02 AM
  6. Calculate number of business days excluding weekends and holidays?
    By sethi85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2007, 02:11 PM
  7. [SOLVED] Calculate Number of Days Between Dates Minus Weekends
    By Melissa in forum Excel General
    Replies: 3
    Last Post: 03-06-2006, 03:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1