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

Compiler vs Interpreter

Compiler Interpreter Convert all the code into binary format and execute. Convert one statement at a time and execute, then Convert next statement and execute. After conversion, source...

Umasankar Natarajan

0 0

Excel

The 1900 Date System In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of elapsed...

Punit Kumar

1 0

Learning Tip

1. The foundation: a productivity systemLet’s face it, without a solid foundation there is no way you can expect to build new skills and form new habits. My first tip therefore is to adopt a productivity...

Pankaj Kumar Jha

0 0

Concatenate Function

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen MA

0 0

VBA Fixed And Variable String

VBA (Excel VBA, Access VBA, Word VBA, Outllook VBA, Power Point VBA, MS Project VBA) defined two types of string data type, Fixed string and Variable string. Fixed String: Length is fixed, data beyond...

Umasankar Natarajan

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.