PostNet Cornwall View Posted on Oct 17, 2013

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?

1 Answer

Scott

Contributor 38 Answers
Posted on May 05, 2014

Scott

Contributor

Joined: Sep 04, 2011

Answers

Questions

Helped

9830

Points

I assume that the dates you want adjust are in date form and are in regular columns (or rows).
If so, then you can use a formula like this =DATE(YEAR(A3)+1,MONTH(A3),DAY(A3))
where the original date is in cell A3.
You can then copy this formula to calculate all the new dates you need, and then copy the results back over the original dates as VALUES.

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

0helpful

1answer

1988 440 petrol is not getting to the injectors

Needs year make model (what is is).

https://www.google.com/search?q=1988+440

..

Read full answer

Jul 14, 2022 • Cars & Trucks

0helpful

1answer

What years was the White 1477 made

The White 1477 is a sewing machine. (although posted among cars & trucks). I have not found its date of manufacture. There is a picture of it: http://www.doubleveil.net/zssmp/eyecandy.htm

Possibly you can find the date of the machine by contacting the below with a query.

For White/Viking Sewing machines:
31000 Viking Parkway
Westlake, OH 44145
440-808-6550
440-847-0001 (fax)
800-446-2333

http://ismacs.net/white/white-sewing-machine-company-history.html

Read full answer

Jun 11, 2017 • Cars & Trucks

0helpful

1answer

I need to add a year on a number of dates there is more than 440 different dates. Is there a formula on excel that i can use and if there is what is it? Please advise?

Try this:
=EDATE(CellRef,12)

where CellRef refers to the cell with the input date.
Hope this helps.
Regards,
Scott

Read full answer

Oct 17, 2013 • 1996 Italdesign Formula

0helpful

1answer

Fsc part i 2013 result lahore board

This is a very good site. This site uploads every thing on time. Very good site for results date sheet. Please email me the date sheet of fa fsc part 1 on [email protected]
http://paktvfun.com
ResultsNaats Mp3Pdf BooksEssaysGuess PapersDate sheetsWallpapers

Read full answer

Oct 04, 2013 • Cars & Trucks

0helpful

1answer

Remove footer from Excel spredsheet

open the excel spread sheet --go to insert-- find the header & footer symbol--click on it and edit as required.

Read full answer

Aug 03, 2013 • Cars & Trucks

1helpful

2answers

Camry 1994 sec radio reads HELP, need code to reset so we can listen to radio

Here's a sheet that has your code.

And here's how to put it in.

I've scanned the code sheet as two .jpgs so everyone with an older Toyota can save, share, upload, copy, paste and generally spread this helpful info around. One dealership actually wanted $45 just to put these in for me, but another, awesomer one just made me a copy of the sheet for nothing so I'm just paying their good deed forward.

Read full answer

Dec 01, 2011 • 1994 Toyota Camry

0helpful

1answer

Where do i put the transmission oil for puegeot 806 lx auto date of reg 13/2/2001 have no manuel but i dnt know where the automatic tranmission fluid goes plz can you help and is that the right oil the...

First of all we need to know if the vehicle is automatic or manuel? if its automatic then you can ad oil through the ****** dip stick hole and if the vehicle is manuel gears then there is diffrent oil and a diffrent place to put the oil in. Donot put gear oil in power steering.

Read full answer

Sep 08, 2011 • Peugeot Liberte Cars & Trucks

0helpful

2answers

I need to add coolant to my sentra...what kind is the best?

open your owners manual, it will tell you that and many other things. coolant comes in green and orange, it is hard to go wrong, if the car is older than 10 years you are looking at green.

Read full answer

Dec 10, 2010 • Nissan Sentra Cars & Trucks

0helpful

1answer

I try to reset the oil by turning ignition to on aand pressing to pedal all the way down under 5 second, but still light wont go off

Depending on what type and year car you have its diffrent ways for diffrent cars, but you need to turn the key on and with in 5 sec, push pedal to floor 3 times, light should blink then turn key off and then start engine light should go out,. let me know if this doesnt work and list the year make and model car. hope this helps.

Read full answer

Aug 30, 2010 • Pontiac Grand Am Cars & Trucks

0helpful

2answers

Honda Prelude?

Hi Dariux!
Go to http://www.autohausaz.com/honda-auto-parts/honda-vehicle-identification-numbers.html for an excellent explanantion and decipering of Honda VIN numbers.
Hope this helps, and don't forget to rate my response!
Thanks!
-WildBill

Read full answer

Jun 15, 2008 • Honda Prelude Cars & Trucks

Not finding what you are looking for?

View Most Popular

1996 Formula

Cars & Trucks

1988 440 petrol is not getting to the injectors

Cars & Trucks

102 views

Ask a Question

Usually answered in minutes!

Check Out the Latest Top Trucks Report!

View all Fixya Reports

Are you an Italdesign Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Have a manual for 1996 Italdesign Formula? Or just drag it here!

Related Topics:

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?

1 Answer

Scott

Add Your Answer

Attachments: Added items

Related Questions:

1988 440 petrol is not getting to the injectors

What years was the White 1477 made

I need to add a year on a number of dates there is more than 440 different dates. Is there a formula on excel that i can use and if there is what is it? Please advise?

Fsc part i 2013 result lahore board

Remove footer from Excel spredsheet

Camry 1994 sec radio reads HELP, need code to reset so we can listen to radio

Where do i put the transmission oil for puegeot 806 lx auto date of reg 13/2/2001 have no manuel but i dnt know where the automatic tranmission fluid goes plz can you help and is that the right oil the...

I need to add coolant to my sentra...what kind is the best?

I try to reset the oil by turning ignition to on aand pressing to pedal all the way down under 5 second, but still light wont go off

Honda Prelude?

Not finding what you are looking for?

1996 Formula

1988 440 petrol is not getting to the injectors

Ask a Question

Check Out the Latest Top Trucks Report!

Top Italdesign Experts

ZJ Limited

john h

Arnie Burke

Are you an Italdesign Expert? Answer questions, earn points and help others

Manuals & User Guides

Related Topics:

I need to add a year to dates on excel spread sheet there are more than 440 diffrent dates....Please help?

1 Answer

Scott

Add Your Answer

Attachments: Added items

Related Questions:

1988 440 petrol is not getting to the injectors

What years was the White 1477 made

I need to add a year on a number of dates there is more than 440 different dates. Is there a formula on excel that i can use and if there is what is it? Please advise?

Fsc part i 2013 result lahore board

Remove footer from Excel spredsheet

Camry 1994 sec radio reads HELP, need code to reset so we can listen to radio

Where do i put the transmission oil for puegeot 806 lx auto date of reg 13/2/2001 have no manuel but i dnt know where the automatic tranmission fluid goes plz can you help and is that the right oil the...

I need to add coolant to my sentra...what kind is the best?

I try to reset the oil by turning ignition to on aand pressing to pedal all the way down under 5 second, but still light wont go off

Honda Prelude?

Not finding what you are looking for?

1996 Formula

1988 440 petrol is not getting to the injectors

Related Topics

Ask a Question

Popular Questions

I need to add a year on a number of dates there is

Removing starter

2nd row stow and go seat won't release to fold down into floor on my 2012 dodge grand caravan

Firing order on a 305 on the cap. Got the wires

Honda civic alarm keeps going off for no reason

Check Out the Latest Top Trucks Report!

Top Italdesign Experts

ZJ Limited

john h

Arnie Burke

Are you an Italdesign Expert? Answer questions, earn points and help others

Manuals & User Guides