L
L
Laid2018-02-14 20:32:34
Google Sheets
Laid, 2018-02-14 20:32:34

How to check for a weekday?

At the moment, this column displays all the days of the month: dl3.joxi.net/drive/2018/02/14/0016/1202/1090738/38...
How to display only Mon-Fri?
The formula for displaying the number: =IF(INDIRECT(ADDRESS(ROW()+36, COLUMN()+1)),INDIRECT(ADDRESS(ROW()+36, COLUMN())), )

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2018-02-14
@stoik_kpd

function DAYWEEK and Function IF
If Sat., then +2 if Sun. +1

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question