Please assist with date formula?

Question

The formula below the line works fine.&nbsp; Now, I need to add the other scenario which is:If the customer name is NVR and ifinvoice is submitted within the week (Friday being the last day), payments for those submittals will be paid 30 days after the friday submittal deadline....If([Customer Name],"nvr"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;FirstDayofPeriod([DW 1 BILLED],Weeks(1),Date(2018,4,6))+Days(30),_____________________________________________var date BillingDate = [DW 1 BILLED];var date SameDayNextMonth = (AdjustMonth($BillingDate,1));If(Day($BillingDate) &lt;= 15, Date(Year($SameDayNextMonth), Month($SameDayNextMonth),10),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date(Year($SameDayNextMonth), Month($SameDayNextMonth),25),

mcfneil · Answer

in order to have a 'rolling' formula that says 'within the week', we need to know the two dates.If one date is [DW 1 BILLED]&nbsp; what is the other date that needs to 'be within the week' of?

buildpro · Answer

It is the same field for both customers [DW 1 BILLED]. That is why I need an IF [Customer Name] is customer 1, then....use date formula 1,Otherwise, use date formula 2

buildpro · Answer

This works fine for Customer 1 [SM JOB]var date BillingDate = [DW 1 BILLED];    var date SameDayNextMonth = (AdjustMonth($BillingDate,1));    &nbsp;    If(Day($BillingDate) &lt;= 15, Date(Year($SameDayNextMonth),  Month($SameDayNextMonth),10),    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  Date(Year($SameDayNextMonth), Month($SameDayNextMonth),25))Now, I need a different date result for Customer 2IF([NVR JOB]=true,...the return date needs to be 30 days after the billing date.Please advise...I cannot seem to get () in correct places.&nbsp; thx

mcfneil · Answer

I think you will need to use something likeIf([NVR Job]=true, $BillingDate+Days(30), ......)

buildpro · Answer

Thank you.&nbsp; Seems to be working. Now that this works, can we add the following:...the actual return date should be on a Friday.For example:&nbsp;&nbsp; &nbsp;Current return date is on&nbsp; Wed., 6/6/18 (but could be on any day within the week)...so final return date should be Fri., 6/8

Forum Discussion

Please assist with date formula?

7 Replies

Related Content

Formula Assistance

Admin Assistance

Formula Assistance

FORMULA ASSISTANCE NEEDED

Assistance Needed to Locate Formula Fields which include Specific String