First Excel and VBA

G

Gazabou

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?
 
J

JE McGimpsey

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
 
G

Gazabou

Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything?
 

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

Creating a Search using a combo box and then creating a report. 4
Excel --> Word 4
Add additional information to excel form after original data entry 0
Exhibits 1
Creating a Chart on form from selected data in query. 0
Using project as a resource tracker 0
Email notifications without opening application 1
How to print two a6 booklets (A5 unfolded) on A4 paper? 3

Top