Finding a holiday

Cyankee

New Member
Joined
Nov 20, 2011
Messages
26
I'm working on a spreadsheet to estimate my paycheck.
I know using =networkdays can help me find out of there is a holiday on any given week, but I need to know if it is on the mon, tue, wed, thu, fri, sat, or sun of the week so I can calculate holiday pay.
I did it once before, but ended up using three rows and 14 columns (using a table) rather than 1 row and 7 columns.
Is there a way to do this without having so many rows and columns? I feel it might require a VB Program and not functions in excel.
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,048
Office Version
365
Platform
Windows
If you use function NETWORDAYS.INTL you can specify which days are declared as weekends. If you have a few minutes, watch this youtube video for an introduction to the function's use: https://www.youtube.com/watch?v=0ajwO2hrNww
 
Last edited:

Cyankee

New Member
Joined
Nov 20, 2011
Messages
26
Thanks, while it is a bit more robust, it doesn't help for what I am looking for.
But I think I figured out a way of doing it on at least one line.
 

Forum statistics

Threads
1,082,389
Messages
5,365,161
Members
400,827
Latest member
Mitzescu

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