I need to auto populate a date that is 30 day

Microsoft Office excel 2007 - upgrade
December 15, 2010 at 08:26:54
Specs: Windows XP
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!!

See More: I need to auto populate a date that is 30 day

Report •

#1
December 15, 2010 at 08:51:56
=E6 + 30

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


Report •

#2
December 15, 2010 at 09:05:23
Wow, thanks. I am kind of embarrassed the solution was that easy! It's pretty clear that I'm a rookie.

Report •

#3
December 15, 2010 at 09:59:53
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 this How-To.


Report •
Related Solutions


Ask Question