+ Reply to Thread
Results 1 to 3 of 3

Last Tuesday of July in year X

  1. #1
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226

    Last Tuesday of July in year X

    The enrty cell, A1 contains a year number, e.g. 2007.

    How do I calculate in another cell the Date of the last Tuesday in July of that year?

    Thanks

    Gabor

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    use this formula

    =DATE(A1,8,1)-WEEKDAY(DATE(A1,8,5))

  3. #3
    Forum Contributor Gabor's Avatar
    Join Date
    02-15-2004
    Location
    Székesfehérvár, Hungary
    MS-Off Ver
    xl2016
    Posts
    226
    Thanks, it's working fine.
    Gabor

+ Reply to Thread

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