1

Using Google Sheets, I need to know what the numeric working day of today is. Somehow I'm just missing something here.
I can already easily determine the number of working days remaining, with

=NETWORKDAYS(today(),eomonth(today(),0)

but how do I figure out that today (October 1) for example, is day 1, Friday will be day 4, Monday will be day 5, etc.?

  • 1
    Is =day(today()) what you're looking for ? – pjmg Oct 1 at 19:53
  • No, I need the work day. – Jonathan van Clute Oct 1 at 22:29
  • What is the problem with =DAY(TODAY()) suggested on a previous comment? – Rubén Oct 1 at 22:58
  • It will give me the day of today including weekends. I need the work day. So Friday would be 4, next Monday would be 5 (not 7), etc. – Jonathan van Clute Oct 1 at 23:06
2

The general formula as you asked is:

=((NETWORKDAYS(today(),eomonth(today(),-1)))*-1)-1

Using fixed values for today "02/10/2019" for dates the above formula would be:

=NETWORKDAYS("30/09/2019","02/10/2019")

We use eomonth(today(),-1), so we take as our starting date the last day of the previous month.
We multiply the whole formula by -1 because we get a negative result.


Please have a go and try out the formula on this TEST spreadsheet

  • Aha... this appears to be exactly what I was trying to come up with. I'll live with it for a bit and mark this as correct if I can't break it. Thank you! – Jonathan van Clute Oct 2 at 12:40
  • "I'll live with it for a bit and mark this as correct if I can't break it". It won't. Please have a go at the test spreadsheet I linked. – marikamitsos Oct 2 at 19:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.