I have 2 cells, 1 headed "Quarter", the other headed "Year" in whcih a user
will enter 1, 2, 3 or 4 in the first cell and the year in the 2nd cell
(obviously).

How do I then convert the entry to a date? e.g. the user enters "1" then
"2006". How do I create the date 01 Jan 2006 or if they enter "3" then 2005.
How do I create the date, 01 Jul 2005?
--
Many Thanks,
CK

If A1 is your Quarter and B1 is your Year:

=DATE(B1,(A1-1)*3+1,1)

hth

Carlo

On Dec 4, 3:23 pm, Crimson King
wrote:
I have 2 cells, 1 headed "Quarter", the other headed "Year" in whcih a user
will enter 1, 2, 3 or 4 in the first cell and the year in the 2nd cell
(obviously).

How do I then convert the entry to a date? e.g. the user enters "1" then
"2006". How do I create the date 01 Jan 2006 or if they enter "3" then 2005.
How do I create the date, 01 Jul 2005?
--
Many Thanks,
CK

Carlo,

I really appreciate the quick response and the spot on answer! Works
beautifully - thank you.
--
Many Thanks,
CK


"carlo" wrote:

If A1 is your Quarter and B1 is your Year:

=DATE(B1,(A1-1)*3+1,1)

hth

Carlo

On Dec 4, 3:23 pm, Crimson King
wrote:
I have 2 cells, 1 headed "Quarter", the other headed "Year" in whcih a user
will enter 1, 2, 3 or 4 in the first cell and the year in the 2nd cell
(obviously).

How do I then convert the entry to a date? e.g. the user enters "1" then
"2006". How do I create the date 01 Jan 2006 or if they enter "3" then 2005.
How do I create the date, 01 Jul 2005?
--
Many Thanks,
CK