• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart update automatic with multiple criteria

Hi,

I am having a chart which based on attached excel data. I need help.
In row 1st i am giving input as Start Date and End Date. In row 2 i need; date should display only till input date (meant between start date and end date of 1st row). Also values which is in row 3 should change based on date.


Thanks
 

Attachments

  • Link Availabilty 01-jan to 31-jan-2016 - Copy.xlsb
    342.8 KB · Views: 8
Hi,

Check the file...I did not validate the results
 

Attachments

  • Copy of Link Availabilty 01-jan to 31-jan-2016 - Copy.xlsb
    340.3 KB · Views: 12
Hi Asheesh,

Thank you very much. Formula for input range date works perfectly fine.

But in 3rd where i need value should change based on header date. like if i am putting start date 20th Jan and end 22nd Jan. Then the value should come for only between both dates. Which is coming correct.

But when i am putting start date 25th Jan and end date 5th Feb. which value does not having in any data sheet. but it is also appearing as availability present. Please help for this case.



Thanks once again.
 

Attachments

  • Copy of Link Availabilty 01-jan to 31-jan-2016 - Copy.xlsb
    341.1 KB · Views: 4
You changed my all effort. It like what i have prepared with whole day was nothing.

You changed it with your master skill.

:Awesome Thank you for your kind support. you are really appreciable.
 
Back
Top