Excel table and vba question

  • Thread starter Thread starter Gazabou
  • Start date Start date
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
 
Hi
not so sure how your spreadsheet layout looks like. Could you post some
example rows of data (plain text - no attachment please)
 
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
 
Hi
and how do you separate the different dates in cell A5 (with a coma)?
 
A5 dates are not seperated by comas, just entered as dates that store
in that cell, Should there be
 
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?
 
A5 must be a VB question as I new at formulas. Comas and the to stor
these dates for A6 is first try
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Need magic Excel formula for Date calculation 2
Conditional formatting in Excel 2010 2
Excel Changing chart label colors based on a value in a cell 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to get an end date for a schedule excluding Sundays? 5
Trailing 30 days sum calculation with excel 1
Auto-populate other cells based on dates 2

Back
Top