Excel table and vba question

G

Gazabou

I have a table called employee schedule with the column days missed i
it. How do I get the total of days missed number from the dates in
previuos cell which holds al;l the dates that were missed?
Thanks
Gazabo
 
F

Frank Kabel

Hi
not so sure how your spreadsheet layout looks like. Could you post some
example rows of data (plain text - no attachment please)
 
G

Gazabou

A1:A6 where A4 is scheule days worked, A5 list all the dates that wer
missed, and A6 is the formula to the total number of days from date
entered into A5
 
G

Gazabou

A5 dates are not seperated by comas, just entered as dates that store
in that cell, Should there be
 
F

Frank Kabel

Hi
now I'm a bit confused. I thought you would store multiple values in
this cell. does that mean you overwrite the cell contents with each new
(missed) date?
 
G

Gazabou

A5 must be a VB question as I new at formulas. Comas and the to stor
these dates for A6 is first try
 
Top