Showing the months of a FY

[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

 

[Norman Harker]

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.

 

[Andy B]

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.

 

[Elijah]

Thanks Norman, Andy

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

Elijah