ExcelBanter - I want to count the total number of date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to count the total number of date (https://www.excelbanter.com/excel-worksheet-functions/230679-i-want-count-total-number-date.html)

shital shah

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

All times are GMT +1. The time now is 12:35 AM.