Consecutive dates

D

Diana

I work at a school and need to set up a daily attendance register which obviously excludes week-ends. How do I create these dates e.g. Mon 16 Feb, Tues 17 Feb, Wed 18 Feb etc

PS Love the site, thank you so much it's so helpful
 
F

Frank Kabel

Hi
one way:
in A1 (your starting cell) enter your starting date
in A2 enter
=WORKDAY(A1,1)
copy down
 
J

JMay

FWIW: In addition to Frank's answer, there is an optional Holiday argument
(which you provide by reference in an array of cells). Any Holiday you list
will be "skipped-over" by your formula.
HTH
 
Top