How to get the date of NETWORKDAYS(NOW()-1))

[rajranja]

Hi Guys,


Through networkdays we can get the number of working days between the 2 given dates... but i need which was the privious Networkday from Todays??


Suppose today is "07/02/2011"(Mon) so i need the answer as "04/02/2011"(Fri).. i have tried using this butt..


=NETWORKDAYS(G21-1,G21) ' [G21 = 2/7/2011]


Please help me ...

 

[Hui]

Rajranja

Try =WORKDAY(G21,-1)


or


=WORKDAY(Now(),-1)

 

[Luke M]

Wrong function. NETWORKDAY is designed to return durations, WORKDAY will return the actual date:

=WORKDAY(G21,-1)


Note that both functions have an optional 3rd arguement to include holidays, if desired.

 

[rajranja]

Thanks a lot hui