formul that add 1.5 day, every end of month

Format can't add. Do you have a date column, and where is the 1.5 being
added to?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"how to add 1.5 day every end of mon" <how to add 1.5 day every end of
wrote in message
...
formul that add 1.5 day, every end of month

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