Consecutive dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
one way:
in A1 (your starting cell) enter your starting date
in A2 enter
=WORKDAY(A1,1)
copy down
 
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
 

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

Date Series 4
consecutive dates 2
Excel check if dates are under a range of week 4
vlookup help? 7
how do I set up an annual calendar on one worksheet 3
Windows XP Win2k3 stop error 0xa 1
Identifying Weekends 1
Custom Grouping 1

Back
Top