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.
Aucun commentaire:
Enregistrer un commentaire