working out days between date.
That seems to count evey entry?
I have check the date fields are setup the same.
Any other ideas where im going wrong?
Phil.
"Dave Peterson" wrote:
Maybe...
=COUNTIF(B1:B100,"<"&A1+30)
phil wrote:
Hi
First thank you to the guy and girls that answeed this yesterday but i left
some info out so it it did not work.
In cell B1 to B100 i have a date (radom) In cell A1 i have the date i want
to work out the differece between those in B1-B100 and A1. The in cell C1 i
want to count the dates that are <30 Days i.e: if there are 10 dates <30 days
i want to show 10 in C1.
thanks
Phil.
--
Dave Peterson
|