Date functionality

  • Thread starter Thread starter Crimson King
  • Start date Start date
C

Crimson King

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?
 
Carlo,

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


carlo said:
If A1 is your Quarter and B1 is your Year:

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

hth

Carlo
Click to expand...
 

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

SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) 2
IF Function with Dates 9
Excel date intervals look up 1
Error calculating date 1
sumif to aggregate month to quarter 16
separating date and time 5
Retuyrning a single entry when multiples of the same 3
Dates - Need to display date one month prior to user-entered date 13

Back
Top