Excel formula to calculate working days...

[Ladynat999]

Hi,

I'm trying to work out how to calculate working days (mon-fri) left in a month.
I'm using

=NETWORKDAYS(P3,EOMONTH(P5,0),P2)

but I can't get the days left to equal 3 (working days left in august including todays date and excluding the bank holiday on 29th aug.

HELP!!!

 

[Fluff]

Hi & welcome to MrExcel.
Is this for Excel or for Google Sheets?

 

[Joe4]

Welcome to the Board!

That calculation looks correct to me.
There are 4 work days between 25-Aug and 31-Aug if 29-Aug is a holiday.
Those days are:
25-Aug
26-Aug
30-Aug
31-Aug

Note that today is 26-Aug, not 25-Aug.
So perhaps you need to update the value in cell P3 to get what you want.
If you use:
=TODAY()
it will automatically return today's date.

 

[Anthony47]

...and don't forget that NETWORKDAYS include both the starting and the end date in the calculation; ie NETWORKDAY(Today(), Today()) will return 1
Maybe you need to subtract 1 to get what you need.

 

[Ladynat999]

Hi & welcome to MrExcel.
Is this for Excel or for Google Sheets?

Hi, It is google sheets, you're correct - however it's only the formula I need which is the same for excel and google sheets. I am good at adapting ;oD

 

[Ladynat999]

Welcome to the Board!

That calculation looks correct to me.
There are 4 work days between 25-Aug and 31-Aug if 29-Aug is a holiday.
Those days are:
25-Aug
26-Aug
30-Aug
31-Aug

Note that today is 26-Aug, not 25-Aug.
So perhaps you need to update the value in cell P3 to get what you want.
If you use:
=TODAY()
it will automatically return today's date.

Hi,
I don't want to count today in days worked, and I do want to count today in days remaining.

 

[Ladynat999]

...and don't forget that NETWORKDAYS include both the starting and the end date in the calculation; ie NETWORKDAY(Today(), Today()) will return 1
Maybe you need to subtract 1 to get what you need.

I didn't know that, but it will probably explain why I'm getting 1 too many days remaining. Can I use Today()-1?

 

[Fluff]

It is google sheets, you're correct

In that case you should make that clear in your op & all such questions should be posted in the General Discussion & Other Applications section of the board.
Not all functions work the same way in Sheets & Excel.

 

[Fluff]

I didn't know that, but it will probably explain why I'm getting 1 too many days remaining

You can simply subtract 1 from the result.

 

[Ladynat999]

In that case you should make that clear in your op & all such questions should be posted in the General Discussion & Other Applications section of the board.
Not all functions work the same way in Sheets & Excel.

I know they don't but I just needed the formula - I am able to transfer across if I have the formula. I have been using excel to actually work it out first - I just happened to screenshot google sheets to give you an idea of what I'm using it for.