# Monthly to Cusotm Date Report

1. ## Monthly to Cusotm Date Report

Hi Experts,
I hoper every one is well, I have a file which is created report my month but I need it will change from monthle to custome date (example start date 09/13/20 End Date 09/27/20 etc), I'm using formula in A11 ={IF(ROWS(A\$11:A11)>\$B\$2,"",INDEX(Table9[[#All],[Column1]],SMALL(IF(TEXT(Table9[[#All],[Column1]],"yyyymmm")=\$A\$2&\$A\$3,ROW(Table9[[#All],[Column1]])-ROW(DataFeeding!\$A\$4)+1),ROWS(A\$11:A11))))}

Regards,
Aaru

2. ## Re: Monthly to Cusotm Date Report

Which version of Excel are you using currently?

3. ## Re: Monthly to Cusotm Date Report

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

4. ## Re: Monthly to Cusotm Date Report

Hi AliGW, I'm using MS Excel 2007

5. ## Re: Monthly to Cusotm Date Report

perhaps

=IF(ROWS(A\$11:A11)>\$C\$2,"",INDEX(Table9[[#All],[Column1]],SMALL(IF((Table9[[#All],[Column1]]>=\$B\$2)*(Table9[[#All],[Column1]]<=\$B\$3),ROW(Table9[[#All],[Column1]])-ROW(DataFeeding!\$A\$4)+1),ROWS(A\$11:A11))))}

where b2/b3 are Start/End dates, C2 -No of entries

6. ## Re: Monthly to Cusotm Date Report

Thanks, John, I have applied but it is not working

7. ## Re: Monthly to Cusotm Date Report

I have attached excel file formula is not working

8. ## Re: Monthly to Cusotm Date Report

Explain what you mean by "not working". Wrong result? Error message? What?

9. ## Re: Monthly to Cusotm Date Report

Change C2

=SUMPRODUCT((Table9[[#All],[Column1]]>=\$B\$2)*(Table9[[#All],[Column1]]<=\$B\$3))

It does work!

10. ## Re: Monthly to Cusotm Date Report

Thanks john, I'm talking about A11 which is an update by month, I want it will update by custom date, I have sent sample file.

11. ## Re: Monthly to Cusotm Date Report

I have sent sample file

12. ## Re: Monthly to Cusotm Date Report

I KNOW that! If check the formula: it uses C2 which was incorrect. Why do you think I gave you the new formual?

PLEASE test before saying they do not work!

13. ## Re: Monthly to Cusotm Date Report

I have tried it is working on C3 but, the below report formulas is showing #num.

14. ## Re: Monthly to Cusotm Date Report

Please stop posting pictures. We cannot diagnose a jpg. Post the file.

15. ## Re: Monthly to Cusotm Date Report

ok SIR.........

16. ## Re: Monthly to Cusotm Date Report

See attached -not all completed

17. ## Re: Monthly to Cusotm Date Report

Thank You John, you are excellent.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1