auto populate dates

D

dusty

I am using Excel to keep track of grades and attendance for students. In the
past I have typed in each date of class manually.
Is it possible to auto-populate a row with dates?
if so i would like to input the beginning and ending dates for the course
and even specify which days (mon,tues,thurs,fri) the class is in attendance.

any suggestions?????
thanks
john
 
T

Teethless mama

A2: contain beginning date
A3: =WORKDAY(A2,1)+(WEEKDAY(A2,2)=2)
copy down as far as needed

format cell as: ddd, m/d/yyyy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consecutive dates 2
Access 2003: Need module to add dates to report. 2
Marking cell; totaling all # between marked cell & next marked cel 4
NETWORKDAYS XL2007 problem with calculating Banking Days in a mont 3
How to count comments? 1
Time Sheet End of Month 1
How do I auto-fill dates that are not consecutive across a row? 6
Populate worksheet with data that meets date range criteria 3

Top