date Upto

[#1]

I have 6 tables with a common calender,

morely i hav combined another calender and made duedate,

nw the user wants to see the data as if date upto the duedate,

tht means, user wants to see the records till date selected frm the list box of due date,

hw can i do tht.

[#2]

Some suggestions pls

[#3]

i simplify it again,

i have a duedate column,

i want the user to get the privilege of selecting the date, which will be taken as a limit,

then the corresponding chart to show the records till the date selected by the user

i tried by using input box but it didn happend, dates are not getting visible in input box

Please someone help

[#4]

Pls follow the application,

[#5]

Hey Mohit,

Thnks for the reply and thnks for the shared app
but tht is not serving my requirement,
i have already defined the calender and using it successfully in 6 other sheets designed
wht the user wants is, thr r 2 more cols. D_Date and Actiondate
the user wants to club both the dates and call it as duedate,
and he wants to select the duedate, so tht the whole chart shld show the records till tht date

hw can i do tht...

Please help me out,
m sending the updated excel sheet....

[#6]

Anybody pls, m stuck in this issue frm a very long time............

[#7]

am totally clueless on this .

Gurus any help on this ????/

[amars]

Check attached file.

[#9]

Thanks Amar,

whn i select other dates, o/p is nt coming....

[amars]

Change the expression to

=Count(Distinct If([Mfd date]<Date#(Inputdate),[P Id]))

Thanks