=IF(J4="Monthly",EOMONTH($R4,COLUMNS($H8:H8)-1)-MOD(WEEKDAY(EOMONTH($R4,COLUMNS($H8:H8)-1))+1,7))
Try this and copy towards right
This works for only months
=IF(J4="Monthly",EOMONTH($R4,COLUMNS($H8:H8)-1)-MOD(WEEKDAY(EOMONTH($R4,COLUMNS($H8:H8)-1))+1,7))
Try this and copy towards right
This works for only months
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks