Hi,

Two problems/questions.

A user has a spreadsheet with dates and times mixed in Col E e.g 01/07
(07:30-17:30), 02/07 (10:00-18:00). They appear to have the same format
but assume it may change as a couple of users. It could be for 16 days.

I'm got the first date in Col D but I'm looking to extract the last
date. The above example it would be 02/07. Is the best way find the
last day to use the right function ??

Once I have the start and end date I need to put the info into a table.
Along the top Row 1 it will have the dates for July and in Column A it
will have a individual name. The table should then add a one if it's in
the date range. Trying to display visually how many people on each day.
NOTE SOME ENTRY'S WILL SPILL OVER TO AUG.

Can anyone point me in the right direction

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561464