Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have expenditure variable "Q4-2016", I want to change it to date 12/1/2016
Hi,
try like
=MakeDate(right('Q4-2016',4),right(left('Q4-2016',2),1)*3,1)
or
=MakeDate(right(expenditure,4),right(left(expenditure,2),1)*3,1)
Regards,
May be like this
Date(MakeDate(Right(expenditure, 4), Num(Month(Date#(KeepChar(expenditure, '0123456789-), 'M-YYYY')))*3, 1))
Hi,
try like
=MakeDate(right('Q4-2016',4),right(left('Q4-2016',2),1)*3,1)
or
=MakeDate(right(expenditure,4),right(left(expenditure,2),1)*3,1)
Regards,
Or like (without any string function):
=MakeDate(Year(Date#('Q4-2016', 'QM-YYYY')),Month(Date#('Q4-2016', 'QM-YYYY'))*3)
Hi, Mfikri!
Or like that:
date#(pick(match(left(expenditure,3),'Q1-','Q2-','Q3-','Q4-'),'3/1/','6/1/','9/1/','12/1/')&right(expenditure,4),'MM/DD/YYYY')
It's Work , thank you so much