View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default 1st and 3rd Thursday formula

Hi!

What do want to do if today is less than or equal to the first Thursday of
the month?

The formula to do this would be very long!

Biff

"David" wrote in message
...
Need a formula to display date to satisfy these requirements.
If today is beyond first Thursday of the month: 3rd Thursday
If today is beyond third Thursday of the month: 1st Thursday of next month

--
David