Calculate Date from a date
 

Hi
I am trying to make spreadsheet to calculate a TAX basis period.

in A1 I have Business start date 10/11/2008
So in A2 I want to check what is the YEAR in A1 and get the NEXT 5/4/2009
date there.

So eg if the date in A1 is 12/04/2001 then I want to show the 05/04/2002 in
A2 and so on.

How could I achieve that?

thanks

Calculate Date from a date
 

Try

=DATE(YEAR(A1)+1,4,5)

--
__________________________________
HTH

Bob

"QuickLearner" wrote in message
...
Hi
I am trying to make spreadsheet to calculate a TAX basis period.

in A1 I have Business start date 10/11/2008
So in A2 I want to check what is the YEAR in A1 and get the NEXT 5/4/2009
date there.

So eg if the date in A1 is 12/04/2001 then I want to show the 05/04/2002
in A2 and so on.

How could I achieve that?

thanks

Calculate Date from a date
 

Excellent Bob..

you are a star..




"Bob Phillips" wrote in message
...
Try

=DATE(YEAR(A1)+1,4,5)

--
__________________________________
HTH

Bob

"QuickLearner" wrote in message
...
Hi
I am trying to make spreadsheet to calculate a TAX basis period.

in A1 I have Business start date 10/11/2008
So in A2 I want to check what is the YEAR in A1 and get the NEXT 5/4/2009
date there.

So eg if the date in A1 is 12/04/2001 then I want to show the 05/04/2002
in A2 and so on.

How could I achieve that?

thanks

Calculate Date from a date
 

But if the date is 2 Feb, mightn't the OP want 5 Apr of that year, not of
the next year?
--
David Biddulph

"Bob Phillips" wrote in message
...
Try

=DATE(YEAR(A1)+1,4,5)

--
__________________________________
HTH

Bob

"QuickLearner" wrote in message
...
Hi
I am trying to make spreadsheet to calculate a TAX basis period.

in A1 I have Business start date 10/11/2008
So in A2 I want to check what is the YEAR in A1 and get the NEXT 5/4/2009
date there.

So eg if the date in A1 is 12/04/2001 then I want to show the 05/04/2002
in A2 and so on.

How could I achieve that?

thanks