Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates, Holidays and maternity leave...
Hi All,
I'm trying to create a 'maternity leave' calculator. So far it's easy enough to calculate how much time is owing, accruing, been used, etc. The problem comes because I need to calculate a list of all the holidays that fall during the period. Now it's simple to exclude them, but how do I tell it to list all dates (listed in a given range) that fall after the nominated start date, but before the calculated finish date? This if further compounded by the fact that staff have the choice of taking either Full or Half pay maternity leave. If half pay maternity leave is chosen, then only those holiday dates that fall during the full pay period count, NOT those that might fall in the second haf of the half-pay period. Please advise... Thanks, Ashley. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Holidays between two dates? | Excel Worksheet Functions | |||
Get Holidays in cell/s between star & End dates? | Excel Worksheet Functions | |||
How to exlude holidays from a range of dates | Excel Discussion (Misc queries) | |||
Dates with Holidays question | Excel Discussion (Misc queries) | |||
Skip holidays falling between two dates | Excel Worksheet Functions |