creating an aging report

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" <PSikes@discussions.microsoft.com> wrote in message
news:DBDEC527-75F7-46D7-89E8-83A89657D337@microsoft.com...
> 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
>

"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" <PSikes@discussions.microsoft.com> wrote in message
> news:DBDEC527-75F7-46D7-89E8-83A89657D337@microsoft.com...
> > 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