Results 1 to 8 of 8

check if todays date is bank holiday

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    882

    check if todays date is bank holiday

    Hi All

    Please attached the workbook. In this Column B contains all the bank holidays. i want to write VBA code that will check if todays date is present in column B then display message "Bank Holiday" .

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] IF function using WORKDAYS and a Bank Holiday list - trying to add new holiday dates
    By jowarks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-05-2013, 05:42 AM
  2. Check if date > todays month
    By samz91 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2012, 07:42 PM
  3. holiday calculation around bank holidays
    By y0rk1e72 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2012, 06:55 AM
  4. Code to check if a cell has todays date
    By virencm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2011, 04:55 PM
  5. Check two dates against todays date?
    By oleisbest in forum Excel General
    Replies: 12
    Last Post: 04-22-2010, 07:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1