Formula for different pay rate on weekends only

Topic Labels: Formulas
551 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1

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)