Dates and formulas
 

Is there a formula I can use to calculate the aging of debtors, dates are
entered of course

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

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

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

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

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

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

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