Share via

Using Today and Workday formulas together

Anonymous
2015-12-16T12:39:11+00:00

I can't figure out a formula based on past work days.  B5:B95 is a list of dates (quarters worth), A1=1/1/16, C1=12/31/16

=COUNTIF(B5:B95,"<"&TODAY())        Counts work but includes the weekends

=NETWORKDAYS(A1,C1,A104:A113)    Gives total workdays

I can't seem to combine these two together no matter what I tried.  Can someone please point me in the right direction?  Thanks,

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-17T19:46:34+00:00

    Your welcome, glad for helping

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-12-17T07:32:23+00:00

    Thanks so much for the help.  This was exactly what I needed to get everything working right.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-12-17T02:48:21+00:00

    What exactly are you trying to achieve?

    If you can share some example then may be we can make a attempt to help you resolve your query.

    Was this answer helpful?

    0 comments