Hi,
I am required to calculate the number of days between two dates exclude sunday. Can someone please provide me such formulae?
Thanks
Hi,
I am required to calculate the number of days between two dates exclude sunday. Can someone please provide me such formulae?
Thanks
Last edited by Harrold; 11-03-2011 at 08:32 PM.
try this forumla
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
It looks complicated. Is there a simplier solution?
Thanks
Is there a simplier solution?
Hello Harold
try this formula.
excel 2007, 2010
note:Please Login or Register to view this content.
B1 - start date
B2 - End Date
11 - Sunday only(you can choose )
F2 - cell containing a special holiday that you want to Exclude
Hole That Helps
Similar with NETWORKDAYS Function in excel 2003
Last edited by vlady; 11-02-2011 at 11:16 PM.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi vlady,
Thanks for your reply.
If the end date is empty, how can i have the result display as N/A?
Thanks again
can someone please look into it?
Thanks
Please allow 24 hrs before bumping, you are not the only one waiting for help
If it is urgent you can always try commercial help.
thank you very much indeed
Here you go:
=NETWORKDAYS.INTL(B1,B2,11)
Jeremy
Last edited by arthurbr; 11-03-2011 at 10:42 AM. Reason: Remove com link
Jeremy
please refrain from adding links to commercial sites to your posts.
How come sunday is treated as 11?
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks