Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
MICROSOFT.PUBLIC.EXCEL.MI
Find 2nd & 4th saturday for every month
From
Girish Mahajan
@21:1/5 to
All
on Thu Apr 8 21:53:43 2021
This is a very good conversation.
I do not consider myself as any kind of expert.
However, I thought that I should share a trick that I discovered.
If A1 is the cell with the date, then I have used the following formula in the conditional formatting:
=and(DOW(A1)=7, mod(CEILING(day(A1)/7),2)=1)
It worked for me. This highlights the second and fourth Saturdays.
Girish Mahajan
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
251
Nodes:
16 (
2
/
14
)
Uptime:
171:36:25
Calls:
5,534
Files:
11,674
Messages:
5,102,331