var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need Help with a Weekday Formula
Hoping that someone can assist me with this Weekday formula that I need.
I have two columns, an Actual date and a Due date. I would like to see the difference between the two dates, but I only need the weekdays, not the entire 7 days.
I created a formula using the Today() function, but that gives me 7 days.
How can I get the number of days between Actual and Due date in Weekdays?
Here is my formula:
Here are my two columns:
Actual Date Due Date
I am using Excel 2010, Office 7
Thank you. :-)
There's a function called DateDiff() that accepts a weekday parameter (VBA)
There's the inbuilt DateDif() but I don't know if that does weekdays.
Alternatively some quick google-fu returned this: http://support.microsoft.com/kb/821091