Thread: dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default dates

=IF(DAY(A1)=9,"Yes","No")

--
HTH,
Gary Brown

If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



" wrote:

Hi,

Is it possible to check the a specific date such as 9th of every
month? Any ideas is appreciated.

Tks.

rgds,
newbie