Skip to main content

I am trying to write a formula where if tasks occur on a weekend the normal pay rate is double.


Currently it is as such


HOURS*60 which would calculate the hours/normal rate of 60. however if the work is done on the weekend the pay rate would be 120.

Hi @Sean_Mahoney,

You can use the Weekday() formula for this it will return a number for the day of the week 0-6, 0 for sunday and 6 for saturday.


IF(OR(WEEKDAY({Pay Date})=0, WEEKDAY({Pay Date})=6), {Total Hours}*120, {Total Hours}*60)

Reply


Terms & Conditions