Output data should in Calender format

hari8088 — Wed, 25 Nov 2020 16:16:04 GMT

I have one scenario which i am not able to get output.

Sheet1 is my input and in sheet2 i have given my output format.

expression is sum(data)/sum(data1).

For example when i choose Jan-2017 the output should be

Because jan-2017 month first start from Sun same way when i choose Feb-2017 output should be

Thanks in advance

Re: Output data should in Calender format

devarasu07 — Wed, 29 Mar 2017 04:30:00 GMT

Hi,

Try like this, Thanks

Hope this helps to you

Regards,
Deva

Gysbert_Wassenaar — Wed, 29 Mar 2017 04:31:57 GMT