Calculating difference between working days
Hello,
I have been trying to do find a simple solution to my below question...but I'm stuck. Would appreciate your assistance.
-Let's say, I have a employee that is starting September 27, 2010 (F4)
-Probationary period is set 3 months from starting day
How can I calculate this taking into consideration I only want networking days?
I found the below formula but it does not work as it takes into account weekends.
=DATE(YEAR(F4),MONTH(F4),DAY(F4)+90)
Thank you for your assistance.
=WORKDAY(StartDate,# of Days, Holiday List -optional)
=WORKDAY(F4,90)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Do you have a "=Workday" function available in Excel 2007?
This works fine...thank you.
How about if I can have excel remind me 5 days before that probation is coming to a end?
Use Conditional Formatting with a formula (depending on what cells you want to change color/formatting) like
=WORKDAY(TODAY(),5)>=WORKDAY(F4,90)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks