Networkdays

**grezmel** · 06-06-2018, 06:29 AM

Hi, i'm struggling with the following NETWORKDAYS equation

Cell M8 = 07/05/2018 which is a Monday
Cell A8 = 02/05/2018 which is a Saturday
Therefore I was expecting 5 working days and a value of "0" should return based on the equation below, however it returns "25" as though only 4 working days are counted

=IF(NETWORKDAYS(A8,M8)>4,"0",IF(NETWORKDAYS(A8,M8)=4,"25",IF(NETWORKDAYS(A8,M8)=3,"100",IF(NETWORKDAYS(A8,M8)=2,"250",IF(NETWORKDAYS(A8,M8)=1,"500",IF(NETWORKDAYS(A8,M8)=0,"1000"))))))

I would like to make the equation count as 5 days

Any ideas ?

**jason.b75** · 06-06-2018, 06:42 AM

Check your dates against a calendar, 02/05/2018 is a Wednesday, not a Saturday.

The formula is counting 02/05 wed, 03/05 thurs, 04/05 fri and 07/05 mon

Total 4 days.

**grezmel** · 06-06-2018, 06:45 AM

Apologies, my mistake, for some reason the 5th month in my muddled head was April !

**jason.b75** · 06-06-2018, 06:52 AM

Sometimes the simplest mistake is the hardest to see

Alternative formula for you to have a look,

=LOOKUP(NETWORKDAYS(A8,M8),{0,1,2,3,4,5},{1000,500,250,100,25,0})

In your formula you have the results enclosed in double quotes, "1000" and 1000 are not the same, enclosing numbers in double quotes classifies them as text strings, a habit that is best avoided unless necessary if you look at those results with another formula, or try sorting your data using those, you could encounter problems.

Networkdays

LinkBack

Thread Tools

Rate This Thread

Display

Networkdays

Re: Networkdays

Re: Networkdays

Re: Networkdays

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Networkdays.intl vs networkdays

Need help with an IF within NETWORKDAYS

[SOLVED] NETWORKDAYS Fx

Networkdays

networkdays

[SOLVED] networkdays

[SOLVED] NETWORKDAYS = 0

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions