submission

I'm getting an error message for this IIF statement. My eyes are not seeing where the problem is. IIf(CStr(DateDiff("m",[PDIR Due Date],Now()))=0,1,IIf((CStr(DateDiff("m",[PDIR Submission Date],Now()))<0) AND (CStr(DateDiff("m",[PDIR Completed],Now()))>0),1,0) Thanks! Found it...

Hello Forumers, I have a question about Conditional Formatting. Is it possible to format a cell with a certain fill, depending on the value of the cell on its left? I need to format the cells in the column titled: Actual Submission (Might say Actial on the screenshot - typo) I need to format...

Hi All, Can anybody help me with a formula to measure employee performance. Our department job is to prepare reports , so some reports have frequency , it means the submission of reports are daily/weekly in nature. While others are huge data based which is time consuming. Few are critical in...

<tbody> 26-07-17 Minutes of Meeting AA/GADAG/HH/NH-63/2070/2017-18/100 29-07-17 Submission of Drawings in respect of Box Culverts and Retaining Walls AA/GADAG/HH/NH-63/2070/2017-18/102 26-07-17 Electrical Utility Shifting Bills AA/GADAG/HH/NH-63/2070/2017-18/99 08-08-17 Submission of...

Can someone please help me? I'm using the 2017 version of HTML Maker but it seems to ignore the formatting I use in the worksheet. When I preview the thread prior to submission, the formatting is fine, but when I submit, it disappears. Also, the Excel frame of column headings and formulas used...

I have a query to a report I created on a form website and need to filter it into reports for different people. The table has a column for "Approved By" and a column "Edit Submission" which is a link. I need the Query to filter the table and only give results for a particular Approver, then I...

Hi Everyone, I hope someone has a solution for me on this. I have this macro that will combine a range of cells from daily worksheets onto a worksheet called "Mileage". My finance department has some quirky rules though. 1st, anything that is over 200 miles for a day has to be submitted...

I have an existing workbook created to track/monitor customer service reports for approximately 90 employees, I'm trying to add a userform so that supervisors don't need to constantly change to the employees sheet to enter the data, I'd like the userform to do it for them. I have the userform...