A
Andrew Mackenzie
Hi All,
In cell A1 I have, say, 30-Nov-08. In cell B1 I want a formula to return
the last day of the last month end i.e. 31-Oct-08. In cell C1 I want a
similar formula to return the last day of the last qaurter end i.e.
30-Sep-08. In cell D1 I want a formula to return the last day of the last
year end i.e. 31-Dec-2007.
Can anyone help?
Many thanks in advance,
KR
Andrew
In cell A1 I have, say, 30-Nov-08. In cell B1 I want a formula to return
the last day of the last month end i.e. 31-Oct-08. In cell C1 I want a
similar formula to return the last day of the last qaurter end i.e.
30-Sep-08. In cell D1 I want a formula to return the last day of the last
year end i.e. 31-Dec-2007.
Can anyone help?
Many thanks in advance,
KR
Andrew