Finding weekends and holidays in a list of dates
I have an Excel spreadsheet with a list of dates going back about 20 years. Some dates are missing. I need to find out if these missing dates are weekends or holidays. Is there any way to do this with some type of formula?
I know it seems like a strange request, but believe it or not, I really need to do it! So, any ideas or thoughts?
Use the WEEKDAY function to determine a weekend (The WEEKDAY function will return 0 for Sun and 7 for Sat).
Not sure about the holidays part of what you want though. My first thought is to have a list of holiday dates over the 20 years and see if a date is in that list
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
This will return the day of the week
=TEXT(A12,"dddd")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks