View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Find the first Sunday for a given year?

Eutrapelia,
(nice nickname btw, I trust you have the idea of its meaning in its
original language :))

Assume the year is in A1 and in B1 you put a number from 1(Sunday) to
7(Saturday). The following formula will return the first day of your B1
choice:
=DATE(A1, 1, MOD(7-DATE(A1, 1, 1)+ B1,7)+1)

HTH
Kostis Vezerides