Formula to Populate Weekdays of a Given Month

Karthik Dale

02/05/2017 0 0

If you want to populate weekdays (Monday to Friday) in a range, follow below steps.

Step1: In Cell A1 write any month 1st date. Let’s say 02/01/2017 (Feb 1st 2017)

Step2: In Cell C1 write this formula =WORKDAY.INTL($A$1,IF(OR(WEEKDAY($A$1)=1,WEEKDAY($A$1)=7),ROW(A1),ROW(A1)-1),1)

Step3: Drag Cell C1 formula down…Check the below screenshot

0 Like 0 Dislike

Follow 0

Other Lessons for You

Hide Duplicate Values & Apply Borders Using Conditional Formatting

Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Ankur Sharma

1 0

Hidden Gems of MS Excel - Reapply Filter

Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma

0 0

Dget-Extract From A Database A Single Record That Matches The Condition We Specify

Syntax: DGET(Database, Field, Criteria) The DGET function syntax has the following arguments: Database Required: The range of cells that makes up the list or database. A database is a list of related...

Daniel I

1 0

VBA Tip: Repeating Emp Names N number of times using 4 different loops

Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

Naga Satyanarayana Anantapalli

2 0

Tips of learning Java Language/Other Programming Languages

1.You should know the basic concept: If we talk about programming languages so basic concept are same in all the high level languages. So you should know the basic concept firstly then you can easily understand...

ICreative Solution

0 0

Looking for Excel Macro Training ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Excel Macro Training Classes?

The best tutors for Excel Macro Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Excel Macro Training with the Best Tutors

The best Tutors for Excel Macro Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.