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

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 ascontains 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

Ask Your Question

Weekly Poll