Can someone give me a hand on this?
I have this formula in A1 "=DAY(EOMONTH(TODAY(),0))" which gives me the number of days of current month. I want to substract the holidays located in B1:B10.
Any idea will eb appreciated.
Can someone give me a hand on this?
I have this formula in A1 "=DAY(EOMONTH(TODAY(),0))" which gives me the number of days of current month. I want to substract the holidays located in B1:B10.
Any idea will eb appreciated.
This should do it (using A14 for testing)Replace A13 with Today() and there you go!Formula:Please Login or Register to view this content.
Tim
Never stop learning!
<--- please consider *-ing !
Tim many thanks, it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks