Calculating Leave And Vacations

hi dears
am in need to vacation calculation in excel sheet

Greetings,
The format that you are designing would depend on the leave policy that you have in your organization. There are many formats as shared by the members in this community.
You may consider using the research tab for more such formats. Please do put forward your queries on the bottlenecks that you face while designing them. These formats are your point of reference:
Leave format
Formula
Regards,
(Cite Contribution)

Please let me the formula for following data ??????????????
Date 1 2 3 4 5 6 7 8 Preasent absent leave
status p p p p l l a l ? ? ?
? -want o get the present -absent-leave number in the cells
Regards,
sravanthi.