NA,, How to get rid of on a timesheet.

[richblake74]

Hello all, I tried the Iferror at the start but it is returning an error still.
I am trying to make a timesheet for each month of the year. Anyone know of a great template to use?
Can anyone help with the below link? My problem is with column AF. Again if anyone has a better template this would be much appreciated.
Have a wonderful day

Blake R. - OT Nov'2023 copy.xlsx

1drv.ms

 

[SunnyAlv]

idk i just fix it, N#A in Column AF, thats right like that ?

 

[Fluff]

@SunnyAlv what is the point of that? there is no point in using IF when you return the same value regardless.

 

[Fluff]

@richblake74 What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try changing the formula in AF9 to

=XLOOKUP(AF8,Sheet2!$A:$A,Sheet2!$F:$F,"")

 

[richblake74]

Hello, I want only the dates in row 8 only to be the dates in the Month and year of the cell B4, so September 23 row 8 should only show September days

 

[Fluff]

Clear B7:AF8 & put this in B8 only

=SEQUENCE(,DAY(EOMONTH(B4,0)),B4)

and then in B7 only

=DAY(B8#)