Earliest date using WEEKNUMBER
=IF(B2<B1,A2-WEEKDAY(A2,3),"")
--
David Biddulph
"Jock" wrote in message
...
Hi,
Dates in column A and WEEKNUMBER in cloumn B (referring to A).
How do I display (in C) only the earliest date (without duplicates) for
each
week (Ie the Monday's date)
Thanks,
--
Traa Dy Liooar
Jock
|