View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shital shah shital shah is offline
external usenet poster
 
Posts: 61
Default I want to count the total number of date

Hi to all
I want to count the total number of date
Example:- 26/05/1973
then total of day ie 2+6 =8
than total of all ie 2+6+5+1+9+7+3=33 ie=6
how can I do this when I just enter 26-05-1973 it should give 8in one
column & 6 in other column.
Thanks

****al