working out days between date.
 

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.

working out days between date.
 

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

working out days between date.
 

Try this in C1

=COUNTIF(B1:B100,"=" & A1+30)

Mike

"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.

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

working out days between date.
 

Cheers Mike

I thought thay were the same thing, that will teach me to look next time

"Mike H" wrote:

Phil,


Use my formula or change the < to in Dave's

Mike

"phil" wrote:

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

working out days between date.
 

Phil,


Use my formula or change the < to in Dave's

Mike

"phil" wrote:

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

working out days between date.
 

I guessed wrong which was subtracting from which.

phil wrote:

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


--

Dave Peterson