# Working Day formula between two date **URL:** \ **Category:** Ask for Help\ **Created:** [December 26, 2022, 10:03pm UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065 "2022-12-26T22:03:15Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sanam\_Shrestha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sanam_shrestha/32/51815_2.png) [@Sanam\_Shrestha](https://community.glideapps.com/u/Sanam_Shrestha)\ **Post date:** [December 26, 2022, 10:03pm UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/1 "2022-12-26T22:03:15Z")
I am trying to create a payslip calculator. I need to know the total working days for the month. Is there a way to find the working day between the start date and end date glide table? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 26, 2022, 10:33pm UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/2 "2022-12-26T22:33:30Z")
yes, in Google Sheets formulas, not in Glide ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 27, 2022, 1:30am UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/3 "2022-12-27T01:30:48Z")
> [@Date Range Exclude Sunday AND 1/2 Saturday](https://community.glideapps.com/t/date-range-exclude-sunday-and-1-2-saturday/55717/4): > > Okay, take a look at the below: To get what you need, you’ll need to modify it slightly. The main change will be with the if-then-else (isWorkingDay) column. Instead of returning true, it will need to return a number based on the weekday. So the if-then-else would be: if svStartDate is empty, then null if svEndDate is empty, then null if ActualDate is after svEndDate, then null if Weekday is less than 2, then null if Weekday equals 7, then 0.5 else 1.0 And then your rollup shoul… > [@Excel formula Workdays](https://community.glideapps.com/t/excel-formula-workdays/43674/4): > > Hola @Alexey_Khrolovich There are 2 tricks to get this (one is easier than the other): [image] You must convert Glide date to a value using this format MM/dd/yyyy, you might use the Format Date plugin to achieve this quickly: Later, configure Excel formula plugin using a new date column. You will get a number and not a real date value due to Workday() formula in GS works in this way. Each value shown is the number of days since Dec 30, 1899 so, you have to convert… ---
**Author:** ![Sanam\_Shrestha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sanam_shrestha/32/51815_2.png) [@Sanam\_Shrestha](https://community.glideapps.com/u/Sanam_Shrestha)\ **Post date:** [December 27, 2022, 2:12am UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/4 "2022-12-27T02:12:36Z")
@Jeff_Hager Hi Jeff, really interesting way to solve the problem. Just one more question is there a way to add the date of the next six months automatically in the Glide table? In google Sheets, it’s just dragging to add a date. Not sure how we can achieve this in the Glide table. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 27, 2022, 7:58am UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/5 "2022-12-27T07:58:59Z")
> [@Sanam\_Shrestha](#): > > Just one more question is there a way to add the date of the next six months automatically in the Glide table? > [@If then else with DATE](https://community.glideapps.com/t/if-then-else-with-date/11328/23): > > @Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The same place that Darren got that original formula had a second formula. It looks like that old thread is unlisted now, so I won’t link to it, but the second formula dealt with adding years, and also accounted for leap year, so if you added 1 year to Feb 29th, then the next year if would calculated to Feb 28th instead of March 1st. Essentially it would figure out if the month of the future calculate…