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
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
