This should be simple, but can't seem to find a suitable formula.
If I put the name of a month in cell A1 for instance (June)
I want to have B1 be 01/06/2004
and B2 be 30/06/2004
(UK date format obviously)
If I change A1 to be July, I want July start / end dates in there....
what formula should I use?
any offers gratefully recieved...