![]() ![]() ![]() WORKDAY() excel formula calculates a future / past date by adding / subtracting any number of working days from it. Here is how you can find out payday for all months in a given calendar year :Īssuming months are in column B, from B3 to B14, last working day of first month can be found by WORKDAY() formula: =WORKDAY(B4,-1). So last working day of Jan 2008 is one working day before first day of Feb 2008. Put in other words, last working day of a month is nothing but 1 working day before first day of next month. We can calculate the paydays / payroll periods in excel with simple date formulas: Calculating last working day of a month – Payday for monthly payroll processing in US most companies pay salary on every 2nd Friday / Thursday. It is slightly different in countries where payrolls are processed every 2 weeks. In India salary is usually paid on the last working day of a month – the payday. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |