Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
Is there a formula I can use to calculate the aging of debtors, dates are
entered of course |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
Does anyone know where the Network DAys function is.
"Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
I generally use =now()-B2 Or whatever cell the due date is in. Format
as number. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
It is part of the Analysis Toolpak, goto ToolsAddins and check that addin.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Office Jnr" wrote in message ... Does anyone know where the Network DAys function is. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
Hi Bob, Thanks for this but Toolpak is already checked. I was wondering
whether it is the way my date is formatted? i tried the simple A1-B1 but it is giving me #VALUE "Bob Phillips" wrote: It is part of the Analysis Toolpak, goto ToolsAddins and check that addin. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Office Jnr" wrote in message ... Does anyone know where the Network DAys function is. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
Thanks Widman, this is giving me more of the answer I need. if i format as
number can I still get the due date to show as a date e.g 11/12/2006? "widman" wrote: I generally use =now()-B2 Or whatever cell the due date is in. Format as number. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
format dates as dates, and diferences as numbers. You can add numbers (days)
to dates if you want. a1: purchase 9/5/06 a2: credit 30 (days) a3: sum for due date gives you 10/5/06 a4: =now()-a3 gives you how many days late they are. obviously you can then include an "IF" the balance is over 0 "Office Jnr" wrote: Thanks Widman, this is giving me more of the answer I need. if i format as number can I still get the due date to show as a date e.g 11/12/2006? "widman" wrote: I generally use =now()-B2 Or whatever cell the due date is in. Format as number. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates and formulas
No you do
=NETWORKDAYS(A1,B1) the function takes care of the calculation -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Office Jnr" wrote in message ... Hi Bob, Thanks for this but Toolpak is already checked. I was wondering whether it is the way my date is formatted? i tried the simple A1-B1 but it is giving me #VALUE "Bob Phillips" wrote: It is part of the Analysis Toolpak, goto ToolsAddins and check that addin. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Office Jnr" wrote in message ... Does anyone know where the Network DAys function is. "Office Jnr" wrote: Is there a formula I can use to calculate the aging of debtors, dates are entered of course |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas that matches data and subtract dates | Excel Discussion (Misc queries) | |||
using dates and time in formulas | Excel Discussion (Misc queries) | |||
Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
USING DATES IN FORMULAS | Excel Discussion (Misc queries) | |||
Using dates in formulas | Excel Worksheet Functions |