Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Another date related question from me, hope someone can help.
In my data I have two columns: Quarter and Year. How can I make a date from them where the date will be the last month of each quarter?
For example Q4 2014 would be 01.12.2014, Q3 2014 would be 01.09.2014.
Many thanks
=Date(MakeDate(Right('Q4 2014',4),Mid('Q4 2014',2,1)*3),'DD.MM.YYYY')
hi
try like this
makedate(1999) returns 1999-01-01
makedate(1999) returns 1999-01-01
makedate(99) returns 0099-01-01
makedate(1992,12) returns 1992-12-01
makedate(1999,2,14) returns 1999-02-14
=MakeDate(Mid(YourQuarter,4), Mid(YourQuarter,2,1)*3)
you can use (monthstart(quarterend(yourquarteryeardate))
if you have two fields year and quarter (2 characters) use:
makedate(year, monthstart(right(Quarterstring,1)*3))
Or try
makedate(YearNo,ceil(QtrNo*3)-2)
=Date(MakeDate(Right('Q4 2014',4),Mid('Q4 2014',2,1)*3),'DD.MM.YYYY')
Thank you all!