Aging column

[Jon Lap]

I need to create an aging column. Please help.

*I have created a column that subtracts the due date from the current day's date. However, the rows that have no data, return "35965."

Thanks for the help in advance.

 

[PA HS Teacher]

35965 is the current date.

You just need to change the number formatting to a date format.

Today's date - 0 = Todays date, which in your case is 35965.

 

[Yogi Anand]

I need to create an aging column. Please help.

*I have created a column that subtracts the due date from the current day's date. However, the rows that have no data, return "35965."

Thanks for the help in advance.

Hi Jon Lap:

To add to what the Teacher has stated, if you want to see a blank returned where there is no data, use ...

=IF(A2,TODAY()-A2,"")

Would this do?

 

[Jon Lap]

Thanks much to Yogi and Teacher.