Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date + working days | Excel Worksheet Functions | |||
Can Excel add working days to a date to result in another date? | Excel Worksheet Functions | |||
How do you add 40 working days to a date | Excel Discussion (Misc queries) | |||
Add on 8 working days to a date | Excel Worksheet Functions | |||
date (minus) date = working days diff | Excel Discussion (Misc queries) |