Calculated weekend/holiday
Hello,
I am developing an intranet with SharePoint 2010 and am having difficulty in making a formula.
I made a display with some information to show the birthday of the day, with the main fields: NAME (Text) DEPARTMENT (Text) PHONE (Int) DATE (DateTime) HOLIDAY(checkbox/Yes-No).
First:
I need to bring the birthday / anniversary names that make the weekend (Saturday / Sunday) and show on Monday.
Second:
I need to show the birthday anniversary which is in holiday business day.
Example: the holiday is Friday, edit -> Monday. Thursday -> view on Friday and so on ...
Could someone help me, I tried some more formulas without success.
Thanks.
November 24th, 2010 9:24pm