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 •

#1
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:

=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.


Report •

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

Report •
Related Solutions


Ask Question