|
| 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
May 23rd, 2004, 03:56 PM
|
|||
|
|||
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
May 23rd, 2004, 04:08 PM
|
|||
|
|||
|
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
May 23rd, 2004, 04:12 PM
|
|||
|
|||
|
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
May 23rd, 2004, 05:36 PM
|
|||
|
|||
|
First Excel and VBA
Okay thanks! Do i need to formulaize A4 to Caputure all the dates like (A4=Dates) or anything?
|
|
#5
May 23rd, 2004, 05:44 PM
|
|||
|
|||
|
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
May 23rd, 2004, 05:55 PM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
