Web Development

Ask something
Discussion Locked

Excel Programming Question

0 helpful
4 replies

by techwine

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am doing an invoice for a company & need to put in a due date for billing purposes. How can calculate an automatic due date 30 days from the date when the invoice is issued?

THANKS!

4 replies

by sgt_shultz

given a named cell 'invdate' that contains the invoice issue date, just put this formula in the cell for the due date: =invdate+30
make sure both cells are formatted for date or else you will just get a strange number displayed...

by jschein

either that or simply if the cell that contains the invoice date (located @ e2), just input this where you want the automatic due date:

=sum(e2+30)

That will give you 30 days later...
good luck.

This discussion is closed to new replies.