Return value of specific date that is on the Calendar into respective cell

**danzarette** · 12-15-2013, 12:13 AM

Hi there Experts,

I am new to the forum here and my knowledge to excel formula is limited. So your kind help is greatly appreciated.
I need some help to solve my problem that i have been working on for so long. But couldn't get the result i wanted.

Basically, it is a scheduling of approving or rejecting of request dates. whereby, i will receive the request dates from Google doc form and then i will
extract the data from web into the excel. The data i receive will include the ID, Date request and Remarks.

With the Information in hand, the data will then be "plot" into a schedule (which is a year calender that i have created on excel) base on the ID requested from the web and the ID in the excel.

After plotting, i also want to check if the number requested date exceed the quota set PER DAY, if it exceed, then i have to reject, if its not then approve.

So here comes the problem..
After all the dates have reflected on the calender, I want to get the information from the calender result(which is whether the date is approve or reject) back on to respective ID and Dates requested.

I have attached a example excel for clearer view of my explanation.

Is there any function or macro that can help me achieve what i wanted?
Please help me..

Thank you in advance! =)

**danzarette** · 12-15-2013, 09:25 AM

anyone can help me, or any suggestion to my solution?

It would be great if anyone could help me out with this.

Thank you very much in advance.

**kvsrinivasamurthy** · 12-15-2013, 12:22 PM

Pl see attached file with formula.

**danzarette** · 12-15-2013, 12:32 PM

Originally Posted by kvsrinivasamurthy

Pl see attached file with formula.

OMG!! Thank you so so so much mr kvsrinivasamurthy.
That is exactly what i wanted to achieve.

Thank you very much sir =)

**kvsrinivasamurthy** · 12-16-2013, 12:15 AM

You are welcome.

**danzarette** · 12-18-2013, 09:32 AM

Hi there Experts,

I have come again for another request on top of the previous problems.
I have tried to modify the formula given to solve my problem, but i cant get it right.

Now i need to determine the decision base on ranking of the number in the Rank column. which is than reflected in the calender. But per day basis, it needs to only be green for the top "number of quota set per day" highest ranking.

I have also attached the sample again.
let me know if i need to create a new threat for this.

Thank you in advance!

Sample.xlsx

**danzarette** · 12-20-2013, 11:37 AM

Originally Posted by danzarette

Hi there Experts,

I have come again for another request on top of the previous problems.
I have tried to modify the formula given to solve my problem, but i cant get it right.

Now i need to determine the decision base on ranking of the number in the Rank column. which is than reflected in the calender. But per day basis, it needs to only be green for the top "number of quota set per day" highest ranking.

I have also attached the sample again.
let me know if i need to create a new threat for this.

Thank you in advance!

Attachment 284864

anyone can help me out with this. please?
Thank you very much.

Return value of specific date that is on the Calendar into respective cell

LinkBack

Thread Tools

Rate This Thread

Display

Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Re: Return value of specific date that is on the Calendar into respective cell

Thread Information

Users Browsing this Thread

Similar Threads

Need to return the earliest date respective to one criteria

Calendar that inputs date in a specific cell

Return cell value on calendar for all dates between start date & end date

Connecting date selected on a calendar to a specific cell

Find specific keywords in a string and return them in respective column.

Bookmarks

Bookmarks

Posting Permissions