formul that add 1.5 day, every end of month

  • Thread starter Thread starter Guest
  • Start date Start date
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulate Entire Sheet 1
Setting up a bi-weekly calendar event 2
To show month end date from any date entered 7
formulate email address based on last name & first letter of first 1
how to Export data from Quickbooks into formulated excel spreadshe 3
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Excel Message box with days of month & date. 1
Count # of Saturdays in a month 1

Back
Top