Questions & Answers for: copy dates excel

dates in column B "Yes" or "No" in column C Spreadsheet captures compliance of staff to complete work in time Yes if they achieved it and No if not. I would like excel to count the number of times and

Ad

Question about Excel for PC

1 Answer

...with their specified sorts. You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the

Ad

Question about Excel for PC

1 Answer

...copy/paste. how it works/ For Current Date - you can use the =Now() function in your cell where you want the date. For Contract #, I don't know what you're using, but you can link to a database of ...

Question about Excel for PC

2 Answers

...Excel.Copy-Paste converts into date format even when the excel sheet is ready to accept numbers. Thanks for help. [email protected] it should be =7/4 or =100/30 and excel will give you a numeric result. ...

Question about Excel 2007 Home and Student Edition for PC

2 Answers

...Excel saved a backup copy of it. To check this you will need to go to the folder that the file is saved into and be sure that show hidden files is turned on. You will see a hidden file with a name ...

Question about Windows XP Professional SP3 Full Version OEM for PC

1 Answer

...dates to simple numbers I have a transformed a column of birthdates to years (through help from F3ar13ss). Excel still treats them as birthdates. I would like now to create a new column where the ...

Question about Excel for PC

1 Answer

...excel. It works fine for me time and date stamping when I make an entry in a cell. The problem is when I close the workbook and re open it to make another entry the time and date stamp is no longer ...

Question about Excel 2003 (065-03992) for PC

1 Answer

...Excel and pull down the File Menu and see if there are more than copy or version of your spreadsheet. Look at all... File could have corrupted the Font or could be a Virus. Try just changing the font ...

Question about Wildfire Cell Phone

3 Answers

Excel (.xls), PowerPoint (.ppt) and text (.txt) files. Make sure you have copied the files to the phone's storage card before you open Quick office. See "Copying files to or from the storage card"

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

Not finding what you are looking for?

Ask a Question

Usually answered in minutes!

Popular Products

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computers & Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...