Date Formula Subtracting A day

[ibrahim_shaukat]

Hi, I want to how can i get remaining salary when employee I absent few days and from total salary the days he is absent should be excluded and formula gives me answer. Below are 3 tabs from which I need formula to be completed. Please help me.! @Gareth_Pronovost , W_Vann_Hall anyone please

[andywingrave · Accepted solution]

Hey! Is the absence and benefit data linked in the Employee table (I don’t see them)? if so, you should be able to grab those fields and make the pro-rated salary calculation. If you need them in separate tables (without links) you could use the scripting block here.