I find a lot on net… Pl someone help me...!
I want to take difference between 2 dates which exclude all Sunday with 2nd and 4th Saturday of month.
Thanks
SAGAR
I find a lot on net… Pl someone help me...!
I want to take difference between 2 dates which exclude all Sunday with 2nd and 4th Saturday of month.
Thanks
SAGAR
pls attach sample file.
Hi
What will be your date range (spams to only one month or more then one month)?
regards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
I am So Sorry to respond to this line.
For eg, from 1st Jan till date I want to calculate workdays
Rules: exclude all Sundays; exclude 2nd & 4th sat of every month
I think the simplest way to do this in Excel 2010 is to use NETWORKDAYS.INTL function to exclude Sundays automatically and build a list of 2nd/4th Saturdays and exclude those too as "holidays", e.g. with start date in A2 and end date in B2 use this formula
=NETWORKDAYS.INTL(A2,B2,11,H$2:H$500)
the 11 tells it to exclude Sundays - in H2 put the first Saturday e.g. 14-Jan-2012 and then use this formula in H3 copied down to get a list of all 2nd/4th Sats
=IF(DAY(H2+14)<8,21,14)+H2
Obviously you need to include as many Saturdays as you need to include all the date periods of interest.....
If you really want you can build that holiday list in to the formula but it will make the formula more complex....
Audere est facere
I would be better to use list of holiday, which includes 2nd and 4th saturday, its simple to use networkdays.intl function.
Thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks