Hi,
I need to keep record of the number of days people have off sick from work.
I have a simple END DATE - START DATE formula but I need to ignore any non weekend days
Is there a nice simple solution?
Thanks
Hi,
I need to keep record of the number of days people have off sick from work.
I have a simple END DATE - START DATE formula but I need to ignore any non weekend days
Is there a nice simple solution?
Thanks
Last edited by Gooford; 03-09-2012 at 10:11 AM.
With your start date in A1 and your end date in A2
=NETWORKDAYS(A1,A2)
Hi,
When I type this in I get #NAME?
Is there something missing?
Hi
Inoffice 2003 you have to install anova pack 1 add in
In toll menu select add in and select the addin
You may need office 2033 CD
Regard
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
That's Analysis Toolpak addin....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Oh dear that is not an option as I dont have administrator privileges - is there another function?
With start date in A1 and end date in A2...possibly,
=((A2-A1+WEEKDAY(A1)-WEEKDAY(A2))/7)*5-(WEEKDAY(A1)-WEEKDAY(A2))
Thanks everyone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks