Days OTM Tool is Excel - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » Days OTM Tool is Excel

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

VegasPhil

Premium Member

Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline

22nd Feb 07 at 16:53

Hi,

I need a tool that can calculate how many days one of my property has been on the market in Excel.

For instance, A property that goes on the market on the 5-November 2006 up to today.

Can anyone help? Ta!

Corsa 2.0 16v Vegas - Sold

Tim

Site Administrator

Registered: 21st Apr 00
User status: Offline

22nd Feb 07 at 17:21

=Cell1-Cell2

Where Cell1/2 have the two dates in...

Dom

Member

Registered: 13th Sep 03
User status: Offline

22nd Feb 07 at 17:35

Enter the date that you want to go from, ie: Cell A1 = 01/01/2007 (format the cell so its like that). Then in cell B1 use "=TRUNC(NOW()) - A1" (minus ") and set the cells format to general, should give you the days

edit - can also use =DATEDIF(TODAY(), A1, "D"), where A1 is the same as above, will do the same but you can change the "D" to "Y" or "M" which will calculate whole years or months.

[Edited on 22-02-2007 by Dom]

New Topic

New Poll