WORKDAY or NETWORKDAY

[chally3]

Good afternoon all,

Can anyone help please,

I am trying to return a date on a spreadsheet bases on criteria in 2 cells and am stuck!

Column "AA" is a number - days of inventory left in stock, which is live from our system and I am trying to work out how many work days from today stock will last will last to
.
Any help with a formula appreciated.

I thought in cell AB2 formula =Workdays(today())*AA2 would get the result I am looking for, but sadly not.
The problem being on the extract does not have today's date anywhere I can reference to, which would have been easy

Thank you,

Kind regards
Mark

 

[tyija1995]

Re: WORKDAY or NETWORKDAY Help

How about something like:

=NETWORKDAYS(TODAY(),TODAY()+AA2)

If you want to include bank holidays then use this:

=NETWORKDAYS.INTL(TODAY(),TODAY()+AA2,1,{"01/01/2019";"19/04/2019";"22/04/2019";"06/05/2019";"27/05/2019";"26/08/2019";"25/12/2019";"26/12/2019"})

Note: You can put the bank holidays into cells and link to the cells instead but for copy and pasting reasons I wrote it out manually for you (2019 bank holidays)

 

[chally3]

Re: WORKDAY or NETWORKDAY Help

Just tried the formula and its returning a date of 04/01/1900 (using AA2 cell value as "5" ) I would expect the date to be 5 working days from today.

Thanks

 

[tyija1995]

Re: WORKDAY or NETWORKDAY Help

Sorry I misunderstood, I took the number you had in AA2 (lets say 5) and returned how many working days you have in the next 5 days -> which would be 4 with NETWORKDAYS and 3 with NETWORKDAYS.INTL (as Monday is a bank holiday)

If you just want AA2 as an amount of working days from today then try:

=WORKDAY(TODAY(),AA2)

For example if AA2 is 5 then this returns 30 May 2019