thank you for quick reply

answer to first was spot on thank you
second question i want the date to be the sheet was created and not to
change
i have sheet for each day of a month and i know each sheet as been allocated
a date but i also need to print a copy of each day and sometimes forget to
insert date lol

hope this makes sense

jkf


"Bernard Liengme" wrote in message
...
You have a list of names in a row?
=COUNTA(A1:Z1) for row 1 or =COUNTA(1:1)
In a column ?
=COUNTA(C1:C100) for column C or =COUNTA(C:C)
Whereas COUNT counts numbers, COUNTA counts everything.

=TODAY() add the current date which updates when the file is opened
tomorrow
Using CTRL+; enter the current date in static form - will be yesterday's
date tomorrow

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jkf" wrote in message
...
how do i get a total for a list of names entered in

ie alan billy chris dave ......

also is it possible for the date to be automatically enterd in each sheet

tia

jkf