Relative Content

Tag Archive for dategoogle-sheetsformula

Tracking study and testing within 90 days

I’m trying to create a formula that would allow me to find the difference between a past date and today. If the number of days are 90 or more then the hours worked must be subtracted from the 60 hours allowed. If the number of days between those two dates is less than 90 the number of days needs to be multiplied by 2/3 an hour per day and then the subtract hours worked from this number to show the difference between the targeted hours for that date in the 90 day cycle and the amount of time worked. The formula I have is.