98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using Dates
Using Dates
Resolved · High Priority · Version 2010
Wed 21 Mar 2012, 16:16Delegate Luke said...
Luke has attended:
Excel Intermediate course
Using Dates
Hi there,
I am having trouble with some dates.
How can I create a date in one cell, which will automatically add 1 year onto it in another cell.
Also, if for example I do this for a whole column how can I make the cells blank.
For example:
24/02/2011 , 24/06/2012
,
22/03/2012 , 22/03/2013
Its quite confusing, and if I haven't explained myself let me know.
Many thanks
Wed 21 Mar 2012, 16:52Trainer Paul said...
RE: Using Dates
Hi Luke. The formula I would use would be =a1+365. A1 being your date and 365 representing 365 days in a year.
to have the cells blank Im picking you want to autofull the formula to other cells in Column B that will make sense when you enter a date into column A.
You would need to write an if function for this, ie,
=if(a1="","",a1+365)
"" means blank, so if the cell in column A is blank the cell in column B will be blank but if its not blank it will run your formula.
Hope that helps.
Cheers
Paul
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
