Wanting to remember to run the payroll for my company, I was amazed to discover that Google Calendar does not offer any way to create a recurring calendar entry for the last day of each month. As it turns out, this is one of the examples actually quoted in the iCalendar standard — RFC2445 (on page 43) — so it’s very surprising Google has not implemented a way to manage such entries.
Fortunately Google Calendar does actually support recurring entries for the last day of a month, so it’s possible to hand-craft an .ICS file that can then be imported into Google Calendar. Baptiste Gazul’s helpful blog post started me in the right direction and I was able to craft some entries for my needs with help from the RFC. I saved the quoted text below into a plain-text file with a .ICS suffix and then used Google Calendar’s Import Calendar function to add the entry.
To have a calendar entry for Payday on the last weekday of every month, try:
BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20150331
RRULE:FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-1;WKST=MO
SUMMARY:Payday
DESCRIPTION:Last weekday of each month
END:VEVENT
END:VCALENDAR
Change DTSTART to specify the date of the first payday.
I actually have to run payroll on the Friday before the last weekday of the month; this seems to work:
BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20150417
RRULE:FREQ=MONTHLY;BYDAY=FR;BYSETPOS=-1;WKST=MO
SUMMARY:Run payroll
DESCRIPTION:Friday before last weekday of each month
END:VEVENT
END:VCALENDAR
Filed under: How-to | 1 Comment »
Wild Webmink 