Dal1981
12-06-2011, 06:16 AM
Hi all,
Please can you help me understand my shortcomings in using the WORKDAY function in XL07....
I refer to "Now()" as a name range = 'IsToday'
Then, I wish to calculate the workingdays on from the 1st of the present month - so within the cell I use:
=DATE(YEAR(IsToday),MONTH(IsToday),1)
I have named this range as "THE1ST" (very inventive, I know)
Which all works fine.
Column D has the 'work day due' which is in just a number, ie - 2 = the second working day, so I fugured the below would work:
=WORKDAY(THE1ST,D2)
But say using this month, so my THE1ST = "01/12/2011" and my working day due is say "2" ...the above 'workday' function returns "5/12/2011" NOT the "2/12/2011" (Which was last Friday??!)
What am I over looking or why is this not working within my Excel??!
:dunno
Please can you help me understand my shortcomings in using the WORKDAY function in XL07....
I refer to "Now()" as a name range = 'IsToday'
Then, I wish to calculate the workingdays on from the 1st of the present month - so within the cell I use:
=DATE(YEAR(IsToday),MONTH(IsToday),1)
I have named this range as "THE1ST" (very inventive, I know)
Which all works fine.
Column D has the 'work day due' which is in just a number, ie - 2 = the second working day, so I fugured the below would work:
=WORKDAY(THE1ST,D2)
But say using this month, so my THE1ST = "01/12/2011" and my working day due is say "2" ...the above 'workday' function returns "5/12/2011" NOT the "2/12/2011" (Which was last Friday??!)
What am I over looking or why is this not working within my Excel??!
:dunno