# Aging calculate with column a or b depends upon condition

1. ## Aging calculate with column a or b depends upon condition

Dear expert

i have aging formula to calculate with a or b depends upon condition of a and b column.

I have column in column a and b i want aging depends upon cell value below....

If a column is blank then take aging with b
if b column is blank then take agin with a
if a & b column have date i want calculate aging with latest date.

Find the attachment

you may get understand@!!!!!!

2. ## Re: Aging calculate with column a or b depends upon condition

Put this formula in C2 and copy down.

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Aging calculate with column a or b depends upon condition

And for Column D you could use: =IF(AND(A2="",B2=""),"Not Found",IF(A2 > B2,A2, B2))
provided you have Columns A & B correctly formatted, as I have done for you in the attached Workbook.

4. ## Re: Aging calculate with column a or b depends upon condition

DUDE
ITS WORKING PERFECTLY

IF I ENTER THE FUTURE EITHER A OR B I WANT RESULT IN - MINUS IF A COULMN 02-09-2013 AND B 07-09-2013 RESULT -0-2 DAYS

CAN U MAKE CHANGES

5. ## Re: Aging calculate with column a or b depends upon condition

DUDE
ITS WORKING PERFECTLY

IF I ENTER THE FUTURE EITHER A OR B I WANT RESULT IN - MINUS BUT HERE SHOWS N/A

CAN U MAKE CHANGES
Formula:
`Please Login or Register  to view this content.`

6. ## Re: Aging calculate with column a or b depends upon condition

DUDE I WANT SAME RESULT LIKE IN AGING FORMAT -(0-2 Days)

example if A have 01-09-2013 B have 05-09-2013 so here B have greater than today date so formula has to take 05-09-2013 for aging result i want how many days range of aging from today date, result -(0-2 Days) or -3-5 Days or -6-10 Days or -11-20Days or -21-30 Days or >30 Days...if it A OR B cross today date RESULT in agint with minus

sorry for tro

7. ## Re: Aging calculate with column a or b depends upon condition

YOU'RE WELCOME...DUDE

Formula:
`Please Login or Register  to view this content.`

8. ## Re: Aging calculate with column a or b depends upon condition

Perfect It works 100% Dude You are Alpha for excel....Thanks alot

There are currently 1 users browsing this thread. (0 members and 1 guests)