Results 1 to 3 of 3

Determine the date of the last Sunday in a month

Threaded View

  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Determine the date of the last Sunday in a month

    Good morning all, I hope your XMAS and New Years

    I am seeking a formula that will deliver me the date of specific days in the previous month and the following month, given a specific month as input data.

    eg If I provide March 2011 as my input data, I need to get the dates of:
    - the last Sunday in February 2011
    - the first Saturday in April 2011
    - the second saturday in April 2011

    This will be an ongoing resource, which I will then be copying down indefinitely.
    I know I could go through manually and input dates, but where is the fun in that?

    In the attached example .. .cells B6 to E6 are what I am looking to auto-populate, given cell A6. and then copy down.

    thanks in advance
    Darren
    Attached Files Attached Files
    Last edited by Grimace; 01-27-2011 at 10:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1