Hi,
I have a historic date and I need to find out how many working days there have been from that date until now.
How would I do it using the WORKDAY formula?
Thank you
Nathan
Hi,
I have a historic date and I need to find out how many working days there have been from that date until now.
How would I do it using the WORKDAY formula?
Thank you
Nathan
I need to exclude UK bank holidays too from it. Sorry! I meant to add that in.
Look at functions NETWORKDAYS or NETWORKDAYS.INTL
Got it. Thanks.
I used =Networkday(HistoricDate,TodaysDate,Holiday:List)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks