Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Dates
Hi all,
I am trying to count a number of dates if they are between a certain time scale. For example in column A I have a list of dates spanning many years. In B1 I have Today() and in C1 I have B1-365. I need a formula to count the amount of dates I have between B1 and C1. Can anyone help me with this? Cheers SPL |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Dates
SPL,
=COUNTIF(A:A,"=" & C1)-COUNTIF(A:A, "" & B1) HTH, Bernie MS Excel MVP "PH NEWS" wrote in message ... Hi all, I am trying to count a number of dates if they are between a certain time scale. For example in column A I have a list of dates spanning many years. In B1 I have Today() and in C1 I have B1-365. I need a formula to count the amount of dates I have between B1 and C1. Can anyone help me with this? Cheers SPL |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Dates
Cheers Bernie, much obliged
SPL "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... SPL, =COUNTIF(A:A,"=" & C1)-COUNTIF(A:A, "" & B1) HTH, Bernie MS Excel MVP "PH NEWS" wrote in message ... Hi all, I am trying to count a number of dates if they are between a certain time scale. For example in column A I have a list of dates spanning many years. In B1 I have Today() and in C1 I have B1-365. I need a formula to count the amount of dates I have between B1 and C1. Can anyone help me with this? Cheers SPL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting Dates #2 | Excel Discussion (Misc queries) | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
How to Calculate Dates without counting the weekends | Excel Worksheet Functions | |||
counting entries between two dates? | Excel Worksheet Functions |