jeudi 14 février 2019

adding "workday" into an "if" statement in an excel formula

i want this function to only list workdays of the month , i tried searching for workday implementation in an if function but wasn't able to get something working.

=IF(ROWS(A$1:A1)>DAY(I$3);"";$I$2+ROWS(A$1:A1)-1)

[excel snippet] https://i.stack.imgur.com/5Sp6j.jpg

your help is appreciated

Aucun commentaire:

Enregistrer un commentaire