2 questions

[jkf]

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

 

[Bernard Liengme]

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

 

[jkf]

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