UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕
true

Learn Excel Macro Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

Microsoft Excel > Formula to Populate Weekdays of a Given Month
✕

Search in

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 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Flash Fill: Advance Excel
Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

Trisha J.

0 1
0
How to create drop down function in Excel?
Many times while working you would require to create drop down values in excel. Many people get stuck at this point and think it is very difficult to create dropdowns or maybe macro is required to create...

Ayush Agarwal

1 0
0
Excel-Select All Data/Columns/Rows with One Click
You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, all data/Columns/Rows will be selected in seconds.

Antony

0 0
0
Type Error In VBA
VBA Error Types: There are three types of VBA error that you may encounter when executing an Excel macro. These are: Compile Errors/Syntax errors: Compile Errors are recognized by the VBA compiler as...

Punit Kumar

1 0
0
R programming language
R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and...

ITech Analytic Solutions

0 0
0

Looking for Excel Macro Training ?

Learn from Best Tutors on UrbanPro.

Book a Free Demo

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

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

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2026 All Rights Reserved