Help With Excel - Chicagoland Sportbikes
Chicagoland Sportbikes
 
Open Forum This forum is for all off-topic discussion.

 
LinkBack Thread Tools Display Modes
post #1 of 6 (permalink) Old 04-02-2006, 04:49 PM Thread Starter
Listen to Motley Crue
 
norton's Avatar
 
Join Date: Apr 2005
Location: Illinois 60050
Posts: 2,339
Location: Illinois 60050
Sportbike: POSER
Years Riding: 3 Years
How you found us: Shadrach
           
Help With Excel

Alright I am trying to subtract the following:

December 31, 2006 - Current date (IE: TODAY function in excel)

For instance if I type the function ="12/31/2006"-"04/02/2006" the return result will be 273 (which is what I want).

But the problem arises when I want to have today which happens to be: 04/02/2006 automatically put in. IE: =TODAY() would give you todays date in excel. Keeps coming back VALUE###!!! or whatever. I have spent the last hours trying to figure this out. Please Advise
norton is offline  
Sponsored Links
Advertisement
 
post #2 of 6 (permalink) Old 04-02-2006, 05:06 PM
CLSB's Florida Chapter.
 
MoparBoyy's Avatar
 
Join Date: Apr 2004
Location: Apopka, Florida
Posts: 22,652
Location: Apopka, Florida
Sportbike: Ducati
Years Riding: 3 days
How you found us: unemployment office
           
Send a message via AIM to MoparBoyy
when i want to excel, i just twist the throttle or put my right foot down.. o yeah make sure its in gear first!













i would love to help but i know nothing about MS excel, so in the mean time, i'm just gonna be a smart ass... enjoy!

-Mopar

1997 Dodge Viper GTS
2013 Dodge Dart Rallye
MoparBoyy is offline  
post #3 of 6 (permalink) Old 04-02-2006, 05:08 PM
Moderator
 
maks's Avatar
 
Join Date: Apr 2002
Location: Chicago
Posts: 3,613
Location: Chicago
Sportbike: 2002 CBR F4i
Years Riding: 3
How you found us: Original Gangsta
           
Send a message via AIM to maks
Maybe I'm misunderstanding, but it works fine for me. ="12/31/2006"-TODAY()

That's what you have, right?
maks is offline  
post #4 of 6 (permalink) Old 04-02-2006, 05:12 PM Thread Starter
Listen to Motley Crue
 
norton's Avatar
 
Join Date: Apr 2005
Location: Illinois 60050
Posts: 2,339
Location: Illinois 60050
Sportbike: POSER
Years Riding: 3 Years
How you found us: Shadrach
           
It keeps popping up


9/29/1900

Hold up...let me look at something
norton is offline  
post #5 of 6 (permalink) Old 04-02-2006, 05:13 PM
Moderator
 
maks's Avatar
 
Join Date: Apr 2002
Location: Chicago
Posts: 3,613
Location: Chicago
Sportbike: 2002 CBR F4i
Years Riding: 3
How you found us: Original Gangsta
           
Send a message via AIM to maks
Quote:
Originally Posted by norton
It keeps popping up


9/29/1900

Hold up...let me look at something
Change the cell format, dude.
maks is offline  
post #6 of 6 (permalink) Old 04-02-2006, 05:16 PM Thread Starter
Listen to Motley Crue
 
norton's Avatar
 
Join Date: Apr 2005
Location: Illinois 60050
Posts: 2,339
Location: Illinois 60050
Sportbike: POSER
Years Riding: 3 Years
How you found us: Shadrach
           
Quote:
Originally Posted by maks
Change the cell format, dude.

I know, I just figured that out..

Thats what I get for staring at a screen for the past hour +

Thanks MAKS

Last edited by norton; 04-02-2006 at 05:19 PM.
norton is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Chicagoland Sportbikes 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