Showing the months of a FY

  • Thread starter Thread starter Elijah
  • Start date Start date
E

Elijah

Hi, I have this workbook where in a cell someone can type in the financial
year (e.g., 2000-01) and based on this I'd like to have the start of each
month of the financial year starting from 1 July 2000.

So if a colleague typed in 2000-01 in cell A1, I would want 12 cells (in
B2:B14) to calculate the appropriate date/month, eg 01/07/01, 01/08/01,
01/09/01, 01/10/01, 01/11/01, 01/12/01,
01/01/02 ..

I've looked at various functions but I'm having no luck.

Can anyone help with this?

Elijah
 
Hi Elijah!

It's basically playing around with the DATE function.

B2:
=DATE(LEFT(A1,4),7,1)
B3:
=DATE(YEAR(B2),MONTH(B2)+1,1)
Copy down to B14

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi

Also have a look at EDATE. I think this is part of the Analysis Toolpak
add-in, but it makes life much easier!

Andy.
 
Thanks Norman, Andy

much appreciated. That's exactly what I was looking for - I didn't realise
it was that simple.

Elijah
 
Back
Top