formul that add 1.5 day, every end of month

  • Thread starter how to add 1.5 day every end of mon
  • Start date
B

Bob Phillips

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
[email protected]> wrote in message
news:[email protected]...
 
K

Kassie

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
 
Top