OK, I've got another request.

I have a new report to add to the spreadsheet, a semi-annual report. The specifics vary on the due date, but the way I would like it to work is this:

1. Enter any date in a month as the BaseDate
2. The system returns the last workday of the month as the due date.

I've set a new DocClass as follows:

DocClass - Semi-annual
DueType - WD
Due Value - EndofMonth
ClassComment - BaseDate = any day in target month

I've set the DueType as follows
TypeCode - SA
DueType - Semi-annual
comment - DueDate =WORKDAY(EOMONTH(BaseDate,0)+1,-1) [formula I found online]

Because I still don't fully understand the spreadsheet, I haven't been able to make the above work within your setup; i get a value error.

If I just enter the formula directly into the spreadsheet, it calculates correctly for that cell; however, it also applies the same formula to the rest of the due dates.


So clearly I am doing something wrong. I don't know if I'm missing something behind the scenes.


Any ideas?

thanks