You are not logged in.


Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

#1 02-11-07 13:41:06

RichardG
Verified Member
From: Wirral
Registered: 27-06-04
Posts: 152
Website

Spreadsheet Question

I am trying to make a simple spreadsheet to keep a track of income/expenses etc. I am OK with formula for adding cells together simply but can anyone help in what formula I would need to add to a cell containing dates.

I want to enter a date in the first cell such as 02/11/07 and then add 7days to it for each cell onwards.

Hope this makes sense ? can anyone help ?

Thanks

Richard 

Offline

02-11-07 13:41:06

AdBot
Google AdSense Posting Bot

Re: Spreadsheet Question



#2 02-11-07 13:45:26

Dimmy
Guest

Re: Spreadsheet Question

Click column heading and select properties and set it to date format
a1 enter start date
a2 enter =SUM(A1)+7
then click the little box bottom right corner of a2 and drag down the page, the formula will be repeated

#3 02-11-07 13:55:35

RichardG
Verified Member
From: Wirral
Registered: 27-06-04
Posts: 152
Website

Re: Spreadsheet Question

Thanks for the quick reply Dimmy. I knew there would be a simple way of doing it without having to type in every date !

Thanks again  big_smile big_smile

Offline

#4 02-11-07 21:48:33

Leprechaun
Member
Registered: 19-03-06
Posts: 264

Re: Spreadsheet Question

oh that's not how i did it

i typed in the first 2 dates then highlighted both boxes together and used the little drag handle at the bottom RH corner dragged all the way down to continue with the dates wink

Offline

#5 04-11-07 18:53:11

Carl
Guest

Re: Spreadsheet Question

Similar to Dimmy's answer but you don't need the SUM function. Just =a1 + 7 would suffice.

Carl


Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 713

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 714

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home2/matthutc/public_html/drivertrainingtoday.co.uk/include/parser.php on line 787

#6 06-11-07 22:55:41

EKAL
Verified Member
From: East Kilbride
Registered: 23-04-06
Posts: 1,050
Website

Re: Spreadsheet Question

oh that's not how i did it

i typed in the first 2 dates then highlighted both boxes together and used the little drag handle at the bottom RH corner dragged all the way down to continue with the dates wink

thats the way i would have done it.


DSA ADI, DSA Fleet, RoADAR Diploma, RoADAR Gold.
SAFED for LGV/HGV - SAFED train the trainer
Driver CPC Trainer
www.agnewdrivertraining.co.uk

Offline

#7 21-01-08 07:33:25

ExAdiNigel
Member
From: Plymouth, Devon
Registered: 13-12-04
Posts: 4,739

Re: Spreadsheet Question

Bit like driving really, so many ways to do the same thing and none of them wrong!

Nigel


National Standards Cycling Instructor, Ex Adi

Offline

Board footer

Powered by FluxBB. Developed by Matt Hutchings