Holiday
Hi,
I am using Excel 2003 is there a function that read a date from a cell and recognize if the date is a holiday? Thanks for help! -- Farhad Hodjat |
Holiday
Hi,
take a look to CPearson web related to Holidays http://www.cpearson.com/excel/holidays.htm if this helps please click yes thanks "Farhad" wrote: Hi, I am using Excel 2003 is there a function that read a date from a cell and recognize if the date is a holiday? Thanks for help! -- Farhad Hodjat |
Holiday
You have to tell Excel what dates are holidays.
If you list the dates that are holidays in a range of cells like X1:X10 then you can compare the cell with the date to those holiday dates. A1 = some date =IF(COUNTIF(X1:X10,A1),"Holiday","Not a holiday") -- Biff Microsoft Excel MVP "Farhad" wrote in message ... Hi, I am using Excel 2003 is there a function that read a date from a cell and recognize if the date is a holiday? Thanks for help! -- Farhad Hodjat |
All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com