Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Number of working days remaining this month

Tags:

excel-formula

I am using this formula to show the number of days remaining this month. Is it possible to do this for number of working days?

=EOMONTH(TODAY(),0)-TODAY()
like image 467
Hoody Avatar asked Feb 21 '23 19:02

Hoody

1 Answers

The Analysis Toolpack also provides the function NETWORKDAYS to find the number of working days between two dates.

NETWORKDAYS(start_date,end_date,holidays)

like image 106
DevCoDesign Avatar answered Mar 04 '23 11:03

DevCoDesign
Sign in to Comment

Related questions

Counting cells that contain a certain bit of text without duplicates
Excel Formula - Mapping Values from 3 Columns
COUNTIF function if day of week is Tuesday
Formula to convert ticks to a date in excel
Capitalise any words with less than five characters
How SUMIF function in Excel with brackets and "!" sign works
How to insert Excel formula to cell in Report Builder 3.0?
MIN/MAX on text sort order
Find the frequency and location of a recurring word in a cell in excel
Avoiding index & match #N/A value
Retaining first number after the decimal in python
Excel - list in two columns each unique-pair from two source columns in excel
How to get first significant figure from a number in Excel?
Excel: calculate the amount - the numbers from a cell (58391) in another cell (5+8+3+9+1)

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!