Holiday / Attendance Form

Hello

I have added some dates in 'Holiday Dates' sheet for Hayley and Lisa ( green coloured cells). Now see "July 2009" sheet. See formulas in 'Green coloured" cells. Hope this will help u.

Hi

see attached file. I have added 'Sick' sheet and changed formula in 'July' sheet accordingly. Moreover now I have made use of 'Conditional Formatting." So whenever there is 'H', cel will automatically be green and for "S" (Sick) it will be automatically red.
Hope this helps u.

Bye

You are the man. Thank you so much

Last question...I Promise.

I need to add one more sheet 'Other' I am having trouble with the code/formula. I want it to put an 'O' on the month sheet.

Please help

Again thanks for your help

ta

bud

Hello

added 'Other' sheet and formula changed accordingly. See attached file - 'July sheet'

Hi everyone.

Hope you are all well.

I need to be able to add half ways on the Holiday, Sick and Other sheet (on the spreedsheet attached to previous post).

At the moment I add the halfday on the holiday Tab as 1/2 14/11/2011 and then I have to got the date of the month sheet and Type HH (half day holiday). Is there any way I can get this to automaticlly populate as HH?

Thanks


Bud

Any Ideas anyone?

Thanks

bud

Pl see attached file.

Hi Kvinivasamurthy.

I have downloaded the spreadsheet. What am i looking for?

Thanks

bud

Anyone else got any ideas on how I would do this? I am really struggling.

Thanks

nel

Any Ideas on the half day question anyone.

Any help is appreciated

Thanks

bud

Uploaded file not available.Pl upload the file.Let me try.

Hi kvsrinivasamurthy

Not sure what happened to the attachment. Ihave just uploaded another one.


Many Thanks in advance

bud

See the attached file. HalfHoliday Sheet added. Formula in C3 cell of Jan Sheet is changed and copied to other cells of jan Sheet.Other months pl copy the formula and paste all cells from jan Sheet.Any problem feel free to discuss.
Thanks.

Hi kvsrinivasamurthy


Thanks for your help on this. I know how to do this by adding a new tab "Half Holiday".

Is there a way of just putting 1/2 27/01/2011 on the "Holiday" Tab?

Thanks again for your help.

bud

Pl see the (revised) attached file.I have done changes in 'Holiday' Sheet.Rows 102 to 144 are used.
Now you do not require 'Sick' and 'other' Sheets. All types of leave can be entered in 'Holiday' Sheet.Enties are to me made like this below insted of only date.

For Halfday enter HH,date
For Fullday enter H,date
For Sick enter S,date
For other enter O,date
It will appear in Monthly Sheet.
Formula in Jan Sheet only changed.If you feel ok Copy it to other sheets.
with regards.

Hi kvsrinivasamurthy

You are awesome. Thank you so much

bud