I want to calculate salaries of employees every month, I have annual pay package and the month of joining as the data source. So, I want to automate this process. Edge Cases: 1. Suppose an employee joins on the 16th day of the month. And as per the norms I have to give him salary for the 14 days …

So the end result you want is to view how much salary you have to pay each of your employees in the current month?

Is there any way to implement this :point_up_2: :point_up_2:

I think here’s a logic to get you going. I assume you will pay “partial salary” on the same month. 1st part: The date templates. Create a column to calculate the “joined month” of the employee. Create a column to calculate the “joined year” of the employee. Create a template to join the “joined m…

Info on how to calculate a month’s number of days. [image] Fun with Dates Project Showcase Jean-Claude does not stop here hehe. Darren’s idea made me think about a formula to derive the current month’s number of days. [image] And here we go! Tested some timestamps. N…

How to auto calculate values every month or using no. of days?

Ask for Help

ThinhDinh April 23, 2022, 9:37am 6

Info on how to calculate a month’s number of days.

Topic		Replies	Views
Get the days of the current month Ask for Help	11	157	October 17, 2024
Is rolling up summary values based on dates - is there an easier way to do this? Ask for Help	8	761	October 28, 2022
Automatically update the month every month while keeping the day unchanged Ask for Help	3	139	January 10, 2024
Magic (or not) formula 😁 Ask for Help	4	409	July 9, 2022
🆕 Plugins are live in the Editor! Project Showcase	22	1605	November 6, 2021

How to auto calculate values every month or using no. of days?

Related topics