Calculate Date from a date

Q

QuickLearner

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Calculate date so many days before/after current date. 4
Use excel to calculate an expiration date 1
Excel - Wich Function should I use? 1
Excel 2000 and date math 4
Check if a date comes before/after a range of dates 0
Calculate end date and time 1
Calculate the median value before a specified list 0

Top