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

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History