Solved Help with Excel due date.

September 17, 2013 at 07:27:49
Specs: Windows XP
I am making an invoice and need it to figure a due date from the invoice date.

Any help would be greatly appreciated.

See More: Help with Excel due date.

Report •

September 17, 2013 at 07:50:08
✔ Best Answer
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:


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

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

Report •

September 17, 2013 at 08:06:55
Thank you so much for your help! That solved my problem.

Report •

Related Solutions

Ask Question