Share via

Networkdays function showing negative numbers when dragging cells?

Anonymous
2023-10-25T13:09:03+00:00

Hi,

So, I frequently use the vlookup function and can drag downward without issues to carryover my formula, but I notice that when I use the networkdays funtion, I have to manually type it in cell by cell. What gives?

I even experimented with formatting the cells to make sure they are all set to General where I'm dragging them down. Cell showing 71 is my starting point with manually drag it down producing three negative number outputs. Cell showing 69 is just another cell where I entered it manually again to show how it works properly.

FYI - I'm currently using Office365 Web Excel in a shared spreadsheet.

Microsoft 365 and Office | Excel | For business | 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

Answer accepted by question author

HansV 462.6K Reputation points
2023-10-25T13:18:27+00:00

Make the reference to the cell with 10/25/2023 absolute: select the cell reference in the formula and press F4.

For example, if the first formula is

=NETWORKDAYS(D3, E2)

change it to

=NETWORKDAYS(D2, $E$2)

The $symbols "fixate" the reference.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-25T15:24:54+00:00

    That does the trick! Thank you! I'll have to keep that in mind for any future formula issues I may encounter. $ for anchoring/fixating.

    Was this answer helpful?

    0 comments