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.?
=day(today())
what you're looking for ?=DAY(TODAY())
suggested on a previous comment?