Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting dates within a rnage
hi i have a list of dates some in the past some in the present. I am
trying to total up the dates that are in the future, but it keeps returning an inaccurate number. heres the code I am using. Any ideas or tips would be great sub range("a1").select do until activecell = "" if activecell date then total = total+1 end if activecell.offset(1,0).select loop range("b1") = total |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting dates within a rnage
Guessing a bit, but maybe
sub range("a1").select do until activecell = "" If IsDate(Activecell.Value) Then if activecell date then total = total+1 end if End If activecell.offset(1,0).select loop range("b1") = total -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... hi i have a list of dates some in the past some in the present. I am trying to total up the dates that are in the future, but it keeps returning an inaccurate number. heres the code I am using. Any ideas or tips would be great sub range("a1").select do until activecell = "" if activecell date then total = total+1 end if activecell.offset(1,0).select loop range("b1") = total |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting dates within a rnage
Hi John,
As a first step, following formula will do the job : =COUNTIF(A1:A10,"06.03.2006") if all your dates are located in A1:A10 range, and if today is your reference point ... HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
Rnage Finder | Excel Worksheet Functions | |||
Counting Dates | Excel Worksheet Functions | |||
summing data that match critieria in a rnage | Excel Discussion (Misc queries) |