Hi
I take it you want to calculate leave?
Under each month, you will most likely have a column for leave earned, leave
taken and balance remaining

With your headings in row 1 (Jan, Feb Mar and so on), column headings in row
2, then in row 3, under the Earned heading for each month, enter the
following formula:

=IF(TODAY()C$1,1.5,"")=IF(TODAY()C$1,1.5,""). copy this to each of the
months, and for each employee, and at the end of each month, 1,5 days will be
added automatically for each of them.

HTH

"how to add 1.5 day every end of mon" wrote:

formul that add 1.5 day, every end of month