creating an aging report
"Peo Sjoblom" wrote:
Excel dates are just numbers so if your invoice is in a date format that
excel recognizes just add
=A1+30
=A1+60
and do on where A1 holds the date
--
Regards,
Peo Sjoblom
(No private emails please)
"PSikes" wrote in message
...
Hi,
I'm trying to create an Accounts Receivable "aging report", using Excel
2003. I've got a field (a date field), that provides the date of invoice.
I'd like then to add 30, 60, or 90 days from that date, and call that the
"Due Date" for payment in another column.
Thanks,
Peter
Dang, that was easy. Thanks Peo.
Peter
|