excel - Converting different date formats -

-

this continuation of other question how convert quarter years other format

ok need convert more stuff :)

i need convert yyyy-mm yyww ex. 2022-10 2241 // week 41 because halfway through 0ctober.

i need w.yyww become yyww , v.yyww yyww week in swedish (vecka)

and last not least need have convertion previous question yyyy-quarter(1234) yyww code used that

=1*if(isnumber(-a1),a1,mid(a1,3,2) & choose(right(a1,1),"08",20,33,46))

best case scenario if 1 formula convert of these yyww because referencing cell timeline work.¨

week of month take. took week of day 15 in every month. can take them 4 weeks apart or whatever method u might use. exact week or date not needed take close middle of month.

1 january 02

2 february 07

3 march 11

4 april 15

5 may 19

6 june 24

7 july 28

8 aug 33

9 sep 37

10 oct 41

11 nov 45

12 dec 49

ex. 2019-05 becomes 1919

2023-11 becomes 2345

2016-08 becomes 1633

alright w.yymm yymm , v.yymm yymm same formula of right(d8,4) #1 work.

yymm #2 doesn't need change

yyyy-qq requires =mid(d8,3,2) & choose(right(d8,1),"08",20,33,46) #3

and yyyy.mm requires =mid(d8,3,2)&choose(right(d8,2),"02","07",11,15,19,24,28,33,37,41,45,49) #4

so need combine formulas , choose between them.

easiest choose length... minimizes nesting.

so =if(len(d8)=4,"#2",if(len(d8)=6,"#1",if(mid(d8,5,1)="-","#3","#4")))

or combined, 1* on front:

=1*if(len(d8)=4,d8,if(len(d8)=6,right(d8,4),if(mid(d8,5,1)="-",mid(d8,3,2) & choose(right(d8,1),"08",20,33,46),mid(d8,3,2)&choose(right(d8,2),"02","07",11,15,19,24,28,33,37,41,45,49))))

next time.... think let yourself. have provided technique of getting there, need use evaluate formula , google see did , how did it


Comments

Post a Comment

Popular posts from this blog

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

-
i trying create customuser django project email username , add radio button truck , company. in registration process email-id registered per truck or company. mentioned radio button 'tag' , add manytomany field tag in emailuser model. when makemigrations, raising error : (fields.e300) field defines relation model 'abstractemailuser' either not installed, or abstract. i quite new django , not sure whether have created correct code wants. please me solving this. here code, models.py: import django django.contrib.auth.models import ( abstractbaseuser, baseusermanager, permissionsmixin) django.core.mail import send_mail django.db import models django.utils import timezone django.utils.translation import ugettext_lazy _ class emailusermanager(baseusermanager): """custom manager emailuser.""" def _create_user(self, email, password, is_staff, is_superuser, **extra_fields): """create , save emailus...
Read more

matlab - error with cyclic autocorrelation function -

-
Image
i'm trying code cyclic autocorrelation function in matlab follows: t=0:(n-1); t=t*te; i_alpha=0; tau=-n2*te:te:n2*te; alpha=-1/2:1/n:1/2; ryy_cl=zeros(length(alpha),length(tau)); alpha=alpha/te ind_tau=0; i_alpha=i_alpha+1; k=tau ind_tau=ind_tau+1; if k>0 % ryy_cl(i_alpha,ind_tau)=1/length(sig_bin_syl_mod(1:end- k))*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(1i*2*pi*alpha*t(1+k:length(sig_bin_syl_mod(1:end)))); ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(-1i*2*pi*alpha*t(1:end-k)); else ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1-k:end)).*sig_bin_syl_mod(1:end+k)).*exp(-1i*2*pi*alpha*t(1-k:end)); end end end i'm getting errors, , doesn't show expecting. according below formulae, how can fix it? the code provided incomplete, difficult confidently reproduce error. in particular, haven't de...
Read more

php - Using grpc in Laravel, "Class 'Grpc\ChannelCredentials' not found." -

-
i trying use grpc in laravel project. this part of composer.json file: "require": { ... "datto/protobuf-php": "dev-master", "google/auth": "^0.7.0", "grpc/grpc": "dev-release-0_13", ... } i have generated php file proto file. placed in app/services/ , included in composer.json autoload.files section. have run composer install without issues. i have created route testing. has following code: $client = new vat_service\vatserviceclient('localhost:50051', [ 'credentials' => grpc\channelcredentials::createinsecure() ]); but receive response class 'grpc\channelcredentials' not found. when visit route. the laravel app running in homestead vagrant box. i don't know how proceed. missing dependency? did miss install something? i have solved problem, not sure of below steps solution. things tried: i installed grpc-beta in homestead box (...
Read more