Microsoft Office excel 2007 - upgrade

I am working on a quote sheet. I have the date in cell E6, the quote is valid for 30 days and would like to have the date that the quote expires auto populate in cell E8. Thank you in advance for your help!!

Wow, thanks. I am kind of embarrassed the solution was that easy! It's pretty clear that I'm a rookie.

Don't be embarrassed. Working with Dates & Time in Excel is far from straightforward. This might help:

Excel stores Dates and Times as numbers, with the integer portion of the number being the day (using 1/1/1900 as Day 1) and the decimal portion being a fraction of a day.

For example, I just entered =NOW() in a cell and it displayed:

12/15/10 12:53 PM

I formatted the cell as a number and it displayed:

40527.5378762731

because 12/15/2010 is the 40,527th day since the beginning of Excel time, and

.5378762731 * 24 = 12.909 or almost 13 hours into the day.

That's why you can do "simple" math with Excel Dates and Times.

e.g. Add 1 for each day, add 1/24 for each hour

The point where it gets very tricky is when you are adding or subtracting times that cross the pesky Midnight threshold.

Posting Tip:Before posting Data or VBA Code, read thisHow-To.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History