Dates problem

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
 

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

Last working day of a month 12
Match Dates in Two Cells and Ignore subsequent Cells 1
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Finding a sum by matching two cells with the same identifier 1
Some sort of conditional sum? 3
Date issues 1
Link to previous tab 2
Excel - If Forumula 5

Top