First Excel and VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On A spreadsheet, I would like A4 ( Dates Missed) will show all dates that were entered and A5 would sum the number of days missed from the dates in A4. Can you assist?
 
Hi
how would you enter the dates in cell A4 (separated with a coma?)
 
Your description lacks a lot of detail, so this may or may not be
applicable.

Assume your dates are entered in Column C, with no blanks

Then

A4: =COUNTA(C:C)
A5: =INDEX(C:C,A4)-C1-A4+1
 
Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything?
 
Gazabou said:
Okay thanks! Do i need to formulaize A4 to Caputure all the dates like
(A4=Dates) or anything?
Click to expand...

I really don't know what that means...
 
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

need held for auto date calculation for adding years and substract 1
Excel 2 into 1 6
conditional formatting 4
Excel =SUM(A1=A1+B1) 0
Comparison of columns using Conditional Formatting 3
Subtotaling Quarters (and Years) from Months 4
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Sum number range ignoring numbers formatted as text 0

Back
Top