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.?

4
  • 1
    Is =day(today()) what you're looking for ?
    – pjmg
    Oct 1, 2019 at 19:53
  • No, I need the work day.
    – JVC
    Oct 1, 2019 at 22:29
  • What is the problem with =DAY(TODAY()) suggested on a previous comment?
    – Rubén
    Oct 1, 2019 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.
    – JVC
    Oct 1, 2019 at 23:06

1 Answer 1

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

2
  • 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!
    – JVC
    Oct 2, 2019 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. Oct 2, 2019 at 19:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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