I am making an invoice and need it to figure a due date from the invoice date. Any help would be greatly appreciated.

Dates and Times are stored within Excel as a number. The integer portion is the Date, the decimal portion is the Time. Since each is Day is equal to 1, simply adding the number of days to a Due Date will give you a new date.

With 1/1/2013 in A1, this formula will return 4/1/2013, since that is 90 days later:

=A1+90

See here for a good explanation of how Excel deals with Dates and TImes:

http://www.cpearson.com/excel/datet...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you so much for your help! That solved my problem.

Ask Your Question

Weekly Poll

Do you think Samsung's Bixby will compete well against other phone AI systems?

Discuss in The Lounge

Poll History