Hello all, I've learned alot from this forum over the last year but I have one that I can't seem to jiggle into working and wanted to see if I can get some insight. I'm making a sharepoint facing Time-Off calendar and am almost done but I'm at the point where I'm trying to figure out how to structure displaying the names that get approved off, under the dates they were approved for. Part of me feels like it has something to do with the way we count between days vs how many days.
For example, if you have the 1st through the 10th off, you could =DAYS this, however, the very first day is not counted. It would result in 9, when in fact, you have 10 days off, 1-10. So when I tell a calendar date formula to display the following formula:
The 'greater than or equal to' or 'less than or equal to' isn't registering correctly. I THINK, that's just a hypothesis.Please Login or Register to view this content.
If anyone can take a look and give me some direction, that would be fantastic. In my attached sheet, two examples are actually showing correctly for their respective dates, and I can't figure out why those happen to show correctly, while the others do not.
Bookmarks