We currently use an Excel Timecard for all employees, it has formulas in it to calculate time and Dates.
For instance one of the Cells in the Timecard says "Week Ending" and you put in the date (ie. 2-12-15) then above the Mon - Sun columns the Date pops above each one as such (6-Feb 7-Feb 8-Feb, etc.... )
The formula follows as such:
So Week ending is in Cell R2
So above Sun column the formula is: =R2
Then above Sat column the formula is: =N6-1
Then above Fri column the formula is: =M6-1
and so on all the way till Mon column.
Now what I have done is that we have a lot of iPad users in the Field so I have turned this Excel Timecard into an Interactive PDF form, thus giving the users the dummy proof way of filling out there timecards on an iPad using PDF Expert app.
So far the Form works flawless, I used Adobe LiveCycle to create the form and I have even added the formulas to calculate the time using Formcalc statements.
However the part I'm missing is how to get the "Week Ending" date to populate above the Mon-Sun columns.
So I need help writing a Formcalc statement for this to happen or whatever it takes to get the same results as the Excel timecard date formula.
let me know what you think I can also send you the current Form if that will help as well.
Open in new window