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

Auto populate date VBA code 7
Publisher is filling blank lines with data 2
Count a range that matches the heading 2
Creating a macro to update dates in a word doc 1
Adding cels in a row that correspond to the heading of a column 2
consecutive dates 2
Access 2003: Need module to add dates to report. 3
automatically populating dates in a userform 2

Top