How do I set a start and expiration date using IF function

's Computer Specifications

I want to be able to have the computer to give me a expiration date at the
end of the 6th day starting today

's Computer Specifications

Hi John
You can type a date in one cell e.g. A2 or you can press Ctrl+; semicolon to get
today's date and in an other cell just type =A2+6.
HTH
John
"John A" <(E-Mail Removed)> wrote in message
news:7930632D-C8F1-4242-9BC9-(E-Mail Removed)...
>I want to be able to have the computer to give me a expiration date at the
> end of the 6th day starting today

's Computer Specifications

Hi John,
In the expiration cell enter

=TODAY()+6

"John A" wrote:

> I want to be able to have the computer to give me a expiration date at the
> end of the 6th day starting today

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with more than on expiration Date	Alicia	Microsoft Access Queries	2	30th Sep 2008 08:05 PM
Dealing with date formats on expiration date	bliten_bsas	Microsoft Excel Programming	1	4th Oct 2007 08:47 PM
How can a function/procedure start automaticaly on a certain date	=?Utf-8?B?Sm9obiBTbWl0aA==?=	Microsoft Access	2	26th Dec 2005 12:38 PM
Expiration Date	Muhammad-Ali Younes	Spyware Discussion	10	26th Jun 2005 03:25 AM
Datedif function doesn't work when I use the cell with a date as start date reference	Joy	Microsoft Excel Worksheet Functions	2	3rd Apr 2004 12:47 AM