Thread: Check date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jimmy[_5_] jimmy[_5_] is offline
external usenet poster
 
Posts: 37
Default Check date

Hi all,

I've written the following formula to check if it is the first Monday after
every 29th. It seems work but I don't know it is correct or not, please give
advice, many thanks.

=AND(DAY(G3+7-WEEKDAY(G3-2)-6)=23,DAY(G3+7-WEEKDAY(G3-2)-6)<=29)