Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula for different pay rate on weekends only

Topic Labels: Formulas
100 1
Showing results for 
Search instead for 
Did you mean: 

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)