Hi all,
Here's my problem,
I have a created a Form for users to enter client details and billing info that feeds to a worksheet.
On the form I have an input box for an estimated billing date (EBD).
What I'm trying to do (with little success) is to create a calculation on the form which works out the number of days to billing (ie EBD - NOW()
Then
On the work sheet drop it in one of 4 cells depending on how many days the calculation is. (i.e between 1 -30,31-60,61-90,>90)...
Am pulling my hair out... so if anyone has a brilliant idea I would love to hear from you.
Thanks
Matt
Here's my problem,
I have a created a Form for users to enter client details and billing info that feeds to a worksheet.
On the form I have an input box for an estimated billing date (EBD).
What I'm trying to do (with little success) is to create a calculation on the form which works out the number of days to billing (ie EBD - NOW()
Then
On the work sheet drop it in one of 4 cells depending on how many days the calculation is. (i.e between 1 -30,31-60,61-90,>90)...
Am pulling my hair out... so if anyone has a brilliant idea I would love to hear from you.
Thanks
Matt