Hi I have a spin box that shows the days of the week, I want to be able to limit it to show only the monday dates.
This is my current formula
=WORKDAY(A2,1)
Thanks in advance
Hi I have a spin box that shows the days of the week, I want to be able to limit it to show only the monday dates.
This is my current formula
=WORKDAY(A2,1)
Thanks in advance
Try:
Formula:Please Login or Register to view this content.
It needs to display the actual dates.
You want to show prior monday to that date?
Yes please, sorry I should have been more specific, I need the user to be able to use the spin box and go backwards and forwards in monday only dates
Something like?
Formula:Please Login or Register to view this content.
That works brilliantly, is there any way to make the spin box advance just by one click, at the moment it takes 5-6 clicks to get the next date to show?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks