LinkBack URL
About LinkBacks
Hi I would like to count the no. of days for the week and month from data range.
An excel file attached with necessary details.
Pl. help providing the formula.
Thanks,
Nagesh.
Hi I would like to count the no. of days for the week and month from data range.
An excel file attached with necessary details.
Pl. help providing the formula.
Thanks,
Nagesh.
Here:
Formula:
Please Login or Register to view this content.
Also, since you state that 4 is your expected result then your original formula also might not work properly in some cases so you need to change red part in it too.
Edite: Note that without ,2 it will give you result of 3 because 4th September is Sunday and it will be calculated as week 37. Therefore you must put ,2 in Weekday formula to calculate it as last day of Week 36.
Last edited by zbor; 09-21-2016 at 03:55 AM.
Never use Merged Cells in Excel
Try with a Helper column
B2=WEEKNUM(A2) and drag down.
Now Try
C3=SUMPRODUCT((B2:B367=C2)*(MONTH(A2:A367)=D2))
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
If you leave the helper columns then you just need
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Try this formula. C4 in file
Please Login or Register to view this content.
Dear Mr.ZBOR,
your formula is working fine. Thank you.
Dear Mr. Murthy,
Thank you very much.
Your formula is short, simple and working but it is not working when the dates are in a different sheet and linked to the formula.
For your ready reference, attached the excel file pl. help.
Thanks,
Nagesh.
where the formula is used. what is the actual problem. Pl mark in the file.
Pl. ignore the post. new post follows.
Last edited by nagesh.tvsr; 09-28-2016 at 06:14 AM. Reason: Error in the attachment
Attachment was missing
Last edited by nagesh.tvsr; 09-28-2016 at 05:14 AM. Reason: Attachment was missing
Dear Mr. Murthy,
That issue resolved. Thank you very much.
I actually wanted to calculate No. of working days and working days passed (Completed) in the week (excluding holidays) as of yesterday.
Excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
Thanks for the feed back.
Dear Mr. Murthy,
Pl. help on the No. of No. working days & working days passed also (pl. refer the earlier attachment).
For you it is a very small thing and for me it is a very big thing.
Pl. help.
Thanks,
Nagesh.
I did not find in the attached file where you have used formula. Pl mark it in the file.
Sir,
Pl. find the attachment.
Thanks,
Nagesh.
ARRAY formula in E7
ARRAY formula in E8Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 10-06-2016 at 12:33 AM. Reason: Formulas are corrected.
Dear Mr. Murthy,
Thank you so much for the solutions provided for my issue.
One more help required on putting working days & Working days passed in a fortnight.
Excel file attached with necessary information.
I will be grateful if you can provide this formula too.
Thank you,
Nagesh.
nagesh.tvsr,
if this is new question please open new thread.
Ok. Thank you. New thread generated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks