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

I am looking for a way to find the first weekday of the year, say the first
Sunday or Monday, while giving only the year to excel. For example, if I
type in 2006, I want it to automatically give me the date of the first Monday
of the year. Is there any function or combination of functions that will do
this for me?