How many days late is an invoice from todays date Formula

tsteward · Feb 25th, 2002, 09:31 AM

I have a need to take a spreadsheet with the dated invoice on it and have an excel spreadsheet take todays date and the output to another cell telling me how many days old the invoice is.
Any help would be greatly appreciated!!!!
Thanks.
Tim

Mark W. · Feb 25th, 2002, 09:33 AM

=TODAY()-A1 where A1 contains your invoice date.

[ This Message was edited by: Mark W. on 2002-02-25 08:33 ]

dk · Feb 25th, 2002, 09:34 AM

=Today()-A1

You'll need to format the cell as number.

D

tsteward · Feb 25th, 2002, 10:14 AM

Thanks everyone for such quick responses.

I am new to this group and you guys have made this a great first experience!!!!
Tim

Jack in the UK · Feb 25th, 2002, 12:07 PM

HI

Confused! you work from aged debt analysis (SALES LEDGER)?

So the columns say 30day 60days tell you subjuect to billing cycle?

else your need to apply above my chech EVERY account for invoice date and refer whats due subject to terms of sale ??? and have due adte as well to get the OVERDUE????

HTH

Feb 25th, 2002, 12:07 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	HI Confused! you work from aged debt analysis (SALES LEDGER)? So the columns say 30day 60days tell you subjuect to billing cycle? else your need to apply above my chech EVERY account for invoice date and refer whats due subject to terms of sale ??? and have due adte as well to get the OVERDUE???? HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 09:31 AM	#1
tsteward New Member Join Date: Feb 2002 Location: Tim Posts: 2	I have a need to take a spreadsheet with the dated invoice on it and have an excel spreadsheet take todays date and the output to another cell telling me how many days old the invoice is. Any help would be greatly appreciated!!!! Thanks. Tim

Feb 25th, 2002, 09:33 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=TODAY()-A1 where A1 contains your invoice date. [ This Message was edited by: Mark W. on 2002-02-25 08:33 ]

Feb 25th, 2002, 09:34 AM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	=Today()-A1 You'll need to format the cell as number. D

Feb 25th, 2002, 10:14 AM	#4
tsteward New Member Join Date: Feb 2002 Location: Tim Posts: 2	Thanks everyone for such quick responses. I am new to this group and you guys have made this a great first experience!!!! Tim