Greeting to all
i m running in some problem
i have an attendance sheet which i want to display a month according to Chosen month from drop down list
plz see the attachment
ATTENDANCE Sheet.xlsx
any help from one will be appreciated
Regards
Greeting to all
i m running in some problem
i have an attendance sheet which i want to display a month according to Chosen month from drop down list
plz see the attachment
ATTENDANCE Sheet.xlsx
any help from one will be appreciated
Regards
Last edited by pipsmultan; 08-14-2014 at 01:08 AM. Reason: wrong file uploaded
Try this...
On Sheet2
In D6
In M6Please Login or Register to view this content.
In AF2Please Login or Register to view this content.
In AJ2Please Login or Register to view this content.
Is this what you are trying to achieve?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Superb, Excellent, Brilliant............. yes this want i want trying to achieve
i was working on it from last 2 weeks and you solve it like a piece of Cake
just ONE problem i facing and forgot to mention it
i m facing problem in days & Date of Row 7 and 8, what i m trying to do is i want to change Days & Date of Row 7 and 8 according to month selected from drop down-list (for example) if i select month of "July" from drop down-list than ROW 7 and 8 should display date from "June to July" (23-30) to (1-22 )
like if i select Aug than days & date should display from July (23-31) - Aug (1-22 )
Try this....
In E8
and copy across.Please Login or Register to view this content.
and custom format as dd.
Last edited by sktneer; 08-14-2014 at 02:15 AM.
might be i'm not able to make my problem understandable,
currently the Problem is when i select "July" from drop down-list the Days & Date Display in Row 7 and 8 from "July" and ends on "August".
i want it when i select "July" from drop down-list the Days & Date Display in Row 7 and 8 from "June" and ends on "July". (Starts from "June, 23rd-30th" and ends on "July, 1st-22nd") [Not from "July" and ends on "August". ]
Change the formula in D8 to
The formula in E8 will be same as suggested in post#4 which is dragged across.Please Login or Register to view this content.
Is this what you are trying to achieve?
Yes Exactly now Days & Days are working like a charm
but Now D6, M6, AF2, AJ2 Formula doesn't works according it
I think I am confused and not sure what do you want exactly. While in your post#3, you said the formulas are working fine so what happened now?
sorry abut your confuse
Yes Formula was working fine Before applying the formula of post #6, but the month name D6, M6, & numeric date AF2, AJ2 doesn't changes according to the post #6
i have attache new copy of excel plz check
Attachment 338943
Regards
Your file is corrupt, can't download it, try to upload it again
Regards
here is the new attachment
Attendances.xlsx
Please find the attached sheet.
Is this what you are trying to achieve?
Thank you from the bottom of my heart for your Help. You are really Forum Expert. Your support has made me a HAPPY person and I will forever be grateful. You really a valuable Contributor of this excelforum.com
You're welcome. Glad I could help.
If that takes care of your question, please mark your thread as Solved. (I hope you know how to do that.)
Moreover you may also click * to Add Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks