Aging column

PA HS Teacher

Well-known Member

Joined

Jul 17, 2004

Messages

2,838

• Apr 1, 2007

• #2

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.

 

Upvote 0

Y

Yogi Anand

MrExcel MVP

Joined

Mar 12, 2002

Messages

11,454

• Apr 1, 2007

• #3

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.

Click to expand...

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?

 

Upvote 0

J

Jon Lap

New Member

Joined

Feb 16, 2007

Messages

31

• Apr 2, 2007

• #4

Thanks much to Yogi and Teacher.

 

Upvote 0