samedi 16 février 2019

Displaying specific text matching rules of specific workdays of the month

so i managed to create a function that will generate a column of workdays of a month (column A). i want to be able to generate text in column B, formatted next to the day ( as shown in the attached picture), following the rules highlighted in the colors. your help if appreciated

ive tried looking for if function with instr, disregarding formatting, also looking for Case functions, but no success.

below is the code i use to generate the list of workdays

=IF(WORKDAY(G$2-1;ROW(1:1))>G$3;"";WORKDAY(G$2-1;ROW(1:1)))

expected result should be as in columns C & D in the picture attached.

results in column C & D

Aucun commentaire:

Enregistrer un commentaire