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?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
how would you enter the dates in cell A4 (separated with a coma?)
how would you enter the dates in cell A4 (separated with a coma?)
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
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?
J
JE McGimpsey
Gazabou said: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...
F
Frank Kabel
Hi
you may post an example entry of your cell A4
you may post an example entry of your cell A4