| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing a date with a range of dates
I have a table as follows
A B C D Start Date End Date Employee Vacation Type I then need to create a calendar to how each day in the month and who is available and who has taken a leave and which type of leave. So, I need to search the table for each day of the month to find if it is in the list or not, and if it is, to put the type of leave for THAT person in the calendar view. The calendar looks like this... Date 1/1 1/2 1/3 1/4 Emp1 Emp2 Emp3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
| selecting the first date in a range of dates | Excel Worksheet Functions | |||
| return a date from range, date is between dates in two other cells | Excel Discussion (Misc queries) | |||
| How to get individual dates from a date range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
