Solved how to calculate aging with condition.

November 16, 2017 at 03:46:56
Specs: Windows 7
I want to calculate aging between 2 dates.
Example. A1 having date (10th Oct, 17) and B1 is black then C1 should calculate aging (today()-A1 that would be 37 days and going on.
and if A1 having Same date (10th Oct, 17) and B1 having date (10th Nov, 17) then C1 should calculate aging between B1-A1 and that would be 30 days

See More: how to calculate aging with condition.

Reply ↓  Report •

#1
November 16, 2017 at 06:35:17
✔ Best Answer
A basic IF function should work for you:

=IF(logical_test, value_if_true, value_if_false)

Your logical_test will be to check if B1 is blank, which is the same as contains nothing. B1=""

=IF(B1="",TODAY()-A1,B1-A1)

BTW. "C1 should calculate aging between B1-A1 and that would be 30 days "

Nov 10 - Oct 10 is 31 days, not 30.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
November 16, 2017 at 22:24:41
Thank you for reply...

It's working awesome...

Thanxxx


Reply ↓  Report •
Related Solutions


Ask Question