General Car Related Discussion. To discuss anything that is related to cars and automotive technology that doesnt naturally fit into another forum catagory.

anyone good with excel?

Thread Tools
 
Search this Thread
 
Old 23-12-2005, 07:42 AM
  #1  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default anyone good with excel?

is there any way for doing a sum that will calculate todays date and keep updating itself to stay current?

please tell me there is!
Old 23-12-2005, 07:56 AM
  #2  
Mark 3D
Moderator

iTrader: (29)
 
Mark 3D's Avatar
 
Join Date: Apr 2004
Location: UK
Posts: 10,241
Likes: 0
Received 3 Likes on 2 Posts
Default

this might be what u want?

=today()
Old 23-12-2005, 07:59 AM
  #3  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default

Cheers mate your a star!

thats going to get me some serious brownie points at work!!
Old 23-12-2005, 08:01 AM
  #4  
Mark 3D
Moderator

iTrader: (29)
 
Mark 3D's Avatar
 
Join Date: Apr 2004
Location: UK
Posts: 10,241
Likes: 0
Received 3 Likes on 2 Posts
Default

No worries dude!!
Old 23-12-2005, 08:47 AM
  #5  
Eagle
Super Moderator


iTrader: (2)
 
Eagle's Avatar
 
Join Date: Jun 2003
Location: somwhere in wow
Posts: 18,586
Received 4 Likes on 4 Posts
Default

im lost ... i can honesty say i am crap at excel
Old 23-12-2005, 08:47 AM
  #6  
Jim Galbally
20K+ Super Poster.
 
Jim Galbally's Avatar
 
Join Date: May 2003
Location: Ramsgate, Kent Drives: E39 530D Touring
Posts: 20,599
Likes: 0
Received 0 Likes on 0 Posts
Default

press F1
Old 23-12-2005, 08:48 AM
  #7  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default

Whys that jim?

edit. thought you were talking about the date issue!

cheers for the tip!
Old 23-12-2005, 08:49 AM
  #8  
Eagle
Super Moderator


iTrader: (2)
 
Eagle's Avatar
 
Join Date: Jun 2003
Location: somwhere in wow
Posts: 18,586
Received 4 Likes on 4 Posts
Default

Originally Posted by Jim Galbally
press F1
such great help from the schoolboy
Old 23-12-2005, 01:30 PM
  #9  
BigNige
I've found that life I needed.. It's HERE!!
 
BigNige's Avatar
 
Join Date: Jun 2003
Posts: 1,464
Likes: 0
Received 0 Likes on 0 Posts
Default

Markyd thats the best way of doing it

I use that one ALL the time

Nige
Old 23-12-2005, 01:40 PM
  #10  
wildheart
PassionFord Post Whore!!
iTrader: (4)
 
wildheart's Avatar
 
Join Date: May 2003
Location: Derbyshire
Posts: 6,108
Likes: 0
Received 10 Likes on 9 Posts
Default

Matt,
All i know is you broke your computer looking at gay porn
Old 23-12-2005, 01:43 PM
  #11  
kevandalice
PassionFord Regular
 
kevandalice's Avatar
 
Join Date: May 2004
Location: Bridgwater, Somerset
Posts: 455
Likes: 0
Received 0 Likes on 0 Posts
Default Re: anyone good with excel?

Originally Posted by mattbibs
is there any way for doing a sum that will calculate todays date and keep updating itself to stay current?

please tell me there is!


edit:

just took about 5 seconds using help and 'date' as search word
Old 23-12-2005, 01:51 PM
  #12  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by wildheart
Matt,
All i know is you broke your computer looking at gay porn
Yes i did! its getting fixed ready for xmas tho!
Old 23-12-2005, 01:51 PM
  #13  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default Re: anyone good with excel?

Originally Posted by kevandalice
Originally Posted by mattbibs
is there any way for doing a sum that will calculate todays date and keep updating itself to stay current?

please tell me there is!


edit:

just took about 5 seconds using help and 'date' as search word
i'm a bloke - dont do manuals!!
Old 23-12-2005, 01:54 PM
  #14  
kevandalice
PassionFord Regular
 
kevandalice's Avatar
 
Join Date: May 2004
Location: Bridgwater, Somerset
Posts: 455
Likes: 0
Received 0 Likes on 0 Posts
Default

lol anyway gave me a chance to use one of the new smilies!!
Old 23-12-2005, 01:55 PM
  #15  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default



go for it mate!
Old 23-12-2005, 02:00 PM
  #16  
wildheart
PassionFord Post Whore!!
iTrader: (4)
 
wildheart's Avatar
 
Join Date: May 2003
Location: Derbyshire
Posts: 6,108
Likes: 0
Received 10 Likes on 9 Posts
Default

Originally Posted by mattbibs
Originally Posted by wildheart
Matt,
All i know is you broke your computer looking at gay porn
Yes i did! its getting fixed ready for xmas tho!
Old 23-12-2005, 02:02 PM
  #17  
mattbibs
PassionFord Post Whore!!
Thread Starter
 
mattbibs's Avatar
 
Join Date: Apr 2004
Location: Lincoln
Posts: 7,594
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by wildheart
Originally Posted by mattbibs
Originally Posted by wildheart
Matt,
All i know is you broke your computer looking at gay porn
Yes i did! its getting fixed ready for xmas tho!
coont! i missed the gay word when skim reading!

tis true about the girl on girl porn tho!
Old 23-12-2005, 02:03 PM
  #18  
wildheart
PassionFord Post Whore!!
iTrader: (4)
 
wildheart's Avatar
 
Join Date: May 2003
Location: Derbyshire
Posts: 6,108
Likes: 0
Received 10 Likes on 9 Posts
Default

Too late,you been caught out
Old 23-12-2005, 02:35 PM
  #19  
M Brian
PassionFord Post Whore!!
 
M Brian's Avatar
 
Join Date: May 2003
Location: Peterborough
Posts: 3,936
Likes: 0
Received 0 Likes on 0 Posts
Default

or =now()

updates everytime you save an open I think
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
3doorcozmess
Ford RS Cosworth Parts for Sale
3
15-09-2015 06:06 PM
jessie_rs
Non Ford parts & other stuff for sale
0
07-09-2015 01:27 PM
cbminis
Cars & Parts Wanted.
0
07-09-2015 09:42 AM
turbowag
Cars & Parts Wanted.
0
03-09-2015 08:07 AM



Quick Reply: anyone good with excel?



All times are GMT. The time now is 12:27 PM.