Excel formula question.... - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 3 (permalink) Old 02-03-2005, 08:04 PM Thread Starter
Lifer
 
Join Date: May 2003
Location: Little Rock, AR
Posts: 2,191
Excel formula question....

Ok, i have 2 dates... the date and article was mailed, and the date it was recieved by the recipient. They have 30 days to respond... How can I have excel countdown how many days they have left to respond?

Daniel
danielhv is offline  
Sponsored Links
Advertisement
 
post #2 of 3 (permalink) Old 02-03-2005, 08:24 PM
Googlist-Wikipedian
 
Hunt4m3x's Avatar
 
Join Date: Jul 2002
Location: de_aztec
Posts: 4,814
Get on aim. Send me the file/

2005 Infiniti G35 Sedan Ivory Pearl Premium

2006 Infiniti FX45 Liquid Platinum

2010 Polaris Ranger RZR S Orange Madness







Ban count: 2
Hunt4m3x is offline  
post #3 of 3 (permalink) Old 02-03-2005, 08:40 PM
No Cerveza... No Trabajo
 
01WhiteCobra's Avatar
 
Join Date: Jun 2002
Location: Where's my beer?
Posts: 21,924
If the date you are calculating the 30 days from is in A1 put this formula:

=A1+30-TODAY() & " days remaining"

in the cell you want to display the days remaining. Assumption: A1 is formatted as date.

Obviously adjust A1 to whatever cell you are calculating from. If you are doing the entire column use $A1 and you can paste the formula on down the column.

Last edited by 01WhiteCobra; 02-03-2005 at 08:47 PM.
01WhiteCobra is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome