Workdays Function

K

KeyMike

How can I create a formula that will look at a date, such as today's date,
count the number of workdays from the 1st of the month, and return a date
that is the same number of workdays from the 1st of the previous month?
Thanks in advance for your help.
 
B

Bob Phillips

=WORKDAY(DATE(YEAR(A1),MONTH(A1)-1,1),NETWORKDAYS(DATE(YEAR(A1),MONTH(A1),1)
,A1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top