| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count number of days between 2 dates?
please help!!
A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
Are you trying to count the number of days between the two dates or the
number of workdays? Tyro "doyree" wrote in message ... please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
hi
understand how excel keeps dates format both dates to general. you will see that they are just numbers in c1 put this formula. =b1-a1 answer = 6 days format c1 to general format a1 and b1 to date. it's simple arithmatic. as to getting #name? on net workdays. you may not have the analysis tool pack installed. Regards FSt1 "doyree" wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
You have to install the analysis toolpak.
Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
hi.
perhaps i should have answered tyro's question first. the formula i gave will only show days between dates not workdays. regards FSt1 "FSt1" wrote: hi understand how excel keeps dates format both dates to general. you will see that they are just numbers in c1 put this formula. =b1-a1 answer = 6 days format c1 to general format a1 and b1 to date. it's simple arithmatic. as to getting #name? on net workdays. you may not have the analysis tool pack installed. Regards FSt1 "doyree" wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
"i have two dates shown above in dates format and i would like to count the
days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
i tried
=NETWORKDAYS(B2,A2) but got #NAME? =Networkdays() does require the analysis toolpak in xl2003 and below. I wasn't addressing what formula to use. Tyro wrote: "i have two dates shown above in dates format and i would like to count the days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
The OP said he wanted to count the days between two dates. It's simple
subtraction, not NETWORKDAYS, "Dave Peterson" wrote in message ... i tried =NETWORKDAYS(B2,A2) but got #NAME? =Networkdays() does require the analysis toolpak in xl2003 and below. I wasn't addressing what formula to use. Tyro wrote: "i have two dates shown above in dates format and i would like to count the days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
If you are certain what the original intent was, why post your first response:
Are you trying to count the number of days between the two dates or the number of workdays? Tyro wrote: The OP said he wanted to count the days between two dates. It's simple subtraction, not NETWORKDAYS, "Dave Peterson" wrote in message ... i tried =NETWORKDAYS(B2,A2) but got #NAME? =Networkdays() does require the analysis toolpak in xl2003 and below. I wasn't addressing what formula to use. Tyro wrote: "i have two dates shown above in dates format and i would like to count the days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
Because he said he wanted to count the number of days between two dates,
subtraction, and then used NETWORKDAYS in his formula. That is why I asked: which one do you want? Tyro "Dave Peterson" wrote in message ... If you are certain what the original intent was, why post your first response: Are you trying to count the number of days between the two dates or the number of workdays? Tyro wrote: The OP said he wanted to count the days between two dates. It's simple subtraction, not NETWORKDAYS, "Dave Peterson" wrote in message ... i tried =NETWORKDAYS(B2,A2) but got #NAME? =Networkdays() does require the analysis toolpak in xl2003 and below. I wasn't addressing what formula to use. Tyro wrote: "i have two dates shown above in dates format and i would like to count the days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to count number of days between 2 dates?
Then why are you complaining about my post about loading the analysis toolpak?
I didn't see a response from the OP that would answer your question and remove the ambiguity. Tyro wrote: Because he said he wanted to count the number of days between two dates, subtraction, and then used NETWORKDAYS in his formula. That is why I asked: which one do you want? Tyro "Dave Peterson" wrote in message ... If you are certain what the original intent was, why post your first response: Are you trying to count the number of days between the two dates or the number of workdays? Tyro wrote: The OP said he wanted to count the days between two dates. It's simple subtraction, not NETWORKDAYS, "Dave Peterson" wrote in message ... i tried =NETWORKDAYS(B2,A2) but got #NAME? =Networkdays() does require the analysis toolpak in xl2003 and below. I wasn't addressing what formula to use. Tyro wrote: "i have two dates shown above in dates format and i would like to count the days between those dates." Does not require the installation of the Analysis Toolpak. Tyro "Dave Peterson" wrote in message ... You have to install the analysis toolpak. Tools|Addins|check Analysis Toolpak If it's not listed there, you'll have to install it from the Office CD. doyree wrote: please help!! A B 01/28/08 02/03/08 i have two dates shown above in dates format and i would like to count the days between those dates. i tried =NETWORKDAYS(B2,A2) but got #NAME? can someone please help? thank you! -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| Count number of days between dates BUT IF null to current date | Excel Worksheet Functions | |||
| FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| how would I count dates (not # of days) in cells that fall betwee. | Excel Worksheet Functions | |||
Linear Mode
