Hi,
Every month, we also help our client (around 1000 ) to prepare monthly financial reports and upload their web site. Some of them has specific date required to upload.
In SS, we have total 4 sheets. Each sheets represent 3 month(we can't put 4 sheets into one because limitation of SS:, maximum 5000 rows) . We have one column "specific date". E.g., that client request each month 10th to upload, we put 10 in the column.
We can't set reminder for that because it does not include the month in column .
I have very time consuming way to do is manually change the information in column from date to Month and Date. E.g., I manually change 10 to Sep 10. Is there other way to do?
By the way, does SS has formula like as Current month? I know it has today() but do not see any current month formula
Thanks