Workday Forumla Help

[Joneye]

Hi there,

I would like to count the full year, remove the weekends, and using todays date find out how many days are left in the year, applogies i've zero idea how to create this formula.

 

[Cubist]

Try:

=NETWORKDAYS.INTL(TODAY(),DATE(YEAR(TODAY()),12,31),1)

 

[Joneye]

Try:

=NETWORKDAYS.INTL(TODAY(),DATE(YEAR(TODAY()),12,31),1)

Really apprecaite your help, that works perfectly sir.

 

[Scott Huish]

Curious why you went with NETWORKDAYS.INTL, the regular NETWORKDAYS seems to work as well:
=NETWORKDAYS(TODAY(),DATE(YEAR(TODAY()),12,31))

 

[Cubist]

More flexibility in general. Similar with SUMIFS vs SUMIF. I don't see a reason to use less flexible option.