Can you confirm how your data is laid out? For example...

1) Which cell contains the 'Week Ending' date?

2) Which cells contain the 'Day'?

Quote Originally Posted by chapm4
Ithink that would work, but B15 is coming up with the same date as B10 and since I can't seem to grasp what your formula is doing I can't figure out how to fix it.

Can you help one more time, or explain what the formula is doing?

Thanks very much,
Dave