close

Can anyone provide a formula to find the Monday immediately prior to May
25th (the Canadain Holiday quot;Victoria Dayquot;) for any given year?

Thanks
Ralph Heidecke wrote...
gt;Can anyone provide a formula to find the Monday immediately prior to May
gt;25th (the Canadain Holiday quot;Victoria Dayquot;) for any given year?

=DATE(y,5,25)-WEEKDAY(DATE(y,5,25),3)

assuming you want 25 May if it happens to be a Monday.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()