If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
First Excel and VBA
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?
|
#2
|
|||
|
|||
First Excel and VBA
Hi
how would you enter the dates in cell A4 (separated with a coma?) -- Regards Frank Kabel Frankfurt, Germany Gazabou wrote: 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? |
#3
|
|||
|
|||
First Excel and VBA
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 In article , "Gazabou" wrote: 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? |
#4
|
|||
|
|||
First Excel and VBA
Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything?
|
#5
|
|||
|
|||
First Excel and VBA
In article ,
"Gazabou" wrote: Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything? I really don't know what that means... |
#6
|
|||
|
|||
First Excel and VBA
Hi
you may post an example entry of your cell A4 -- Regards Frank Kabel Frankfurt, Germany Gazabou wrote: Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything? |
Thread Tools | |
Display Modes | |
|
|