Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY
 
Posts: n/a
Default First and last days in months

What is the EARLIEST weekday (i.e., Monday, Thursday, etc) that June
30th can fall on?
What is the LATEST weekday that July 1st can fall on?

  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default First and last days in months

As you can see from the data below, June30th can fall on any weekday:

6/30/2006 Fri
6/30/2007 Sat
6/30/2008 Mon
6/30/2009 Tue
6/30/2010 Wed
6/30/2011 Thu
6/30/2012 Sat
6/30/2013 Sun
6/30/2014 Mon
6/30/2015 Tue
6/30/2016 Thu
6/30/2017 Fri
6/30/2018 Sat
6/30/2019 Sun
6/30/2020 Tue
6/30/2021 Wed
6/30/2022 Thu
6/30/2023 Fri
6/30/2024 Sun
6/30/2025 Mon
6/30/2026 Tue

--
Gary''s Student


"GARY" wrote:

What is the EARLIEST weekday (i.e., Monday, Thursday, etc) that June
30th can fall on?
What is the LATEST weekday that July 1st can fall on?


  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default First and last days in months

Strange question, any date can fall on any day.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GARY" wrote in message
oups.com...
What is the EARLIEST weekday (i.e., Monday, Thursday, etc) that June
30th can fall on?
What is the LATEST weekday that July 1st can fall on?



  #4   Report Post  
Posted to microsoft.public.excel.misc
GARY
 
Posts: n/a
Default First and last days in months

Assuming a "normal" work-week of Monday thru Friday, I'm trying to
define a range of "valid" dates starting on the last 'working-day" in
June and the ending on the first "working-day" in July {not including
Saturday, Sundays or U.S. holidays (whether actual and observed)].

  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default First and last days in months

The last working day of June is

=WORKDAY(WORKDAY(DATE(2006,7,0),1),-1)

The first in July is

=WORKDAY(DATE(2006,7,0),1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GARY" wrote in message
oups.com...
Assuming a "normal" work-week of Monday thru Friday, I'm trying to
define a range of "valid" dates starting on the last 'working-day" in
June and the ending on the first "working-day" in July {not including
Saturday, Sundays or U.S. holidays (whether actual and observed)].





  #6   Report Post  
Posted to microsoft.public.excel.misc
GARY
 
Posts: n/a
Default First and last days in months

For:
=WORKDAY(WORKDAY(DATE(2006,7,0),1),-1)
the cell contains #NAME?

For:
=WORKDAY(DATE(2006,7,0),1)
the cell contains #NAME?

What should be displayed?

  #7   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default First and last days in months

You need to make sure that the Analysis Toolpak is installed (ToolsAddins,
and check the item).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GARY" wrote in message
ups.com...
For:
=WORKDAY(WORKDAY(DATE(2006,7,0),1),-1)
the cell contains #NAME?

For:
=WORKDAY(DATE(2006,7,0),1)
the cell contains #NAME?

What should be displayed?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"