Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?

Do you mean you want to know whether 1st July is a Monday, Tuesday
etc.?

you could use this formula

=TEXT(DATE(2006,7,1),"dddd")

or just put the date in a cell and format that cell as dddd


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523259

Ben,
If you mean day (of week) then:

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu", "Fri","Sat")

Where A1 contains a date

HTH

"ben simpson" wrote:

Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?

What I'm trying to do is find out if the 1st day of July falls within a range
of dates, let say June 25th and July 21st (actual dates can be referenced
easily). Using the formula =DATE(YEAR(TODAY()),7,1) , how can a formula be
created to check that, and if true, return a 3, and if not, than a 0?




"Sloth" wrote:

=DATE(2006,7,1)

or (for current year)

=DATE(YEAR(TODAY()),7,1)

or (to get the day of the week, ie. Sunday, Monday, Etc.

=TEXT(DATE(YEAR(TODAY()),7,1),"dddd")

"ben simpson" wrote:

Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?

=DATE(2006,7,1)

or (for current year)

=DATE(YEAR(TODAY()),7,1)

or (to get the day of the week, ie. Sunday, Monday, Etc.

=TEXT(DATE(YEAR(TODAY()),7,1),"dddd")

"ben simpson" wrote:

Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?

Toppers wrote:
Ben,
If you mean day (of week) then:

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu", "Fri","Sat")
Isn't =TEXT(A1,"ddd") rather simpler?

No daddy. What I'm now re-doing is a time sheet. On the 1st day of July
each year, 3 personal leave days are add for us to use whenever. I need to
add it on that date, and for it to remain visible thru the end of the pay
period, so the total can carry forward.....Thanks....Ben

"daddylonglegs" wrote:


Do you mean you want to know whether 1st July is a Monday, Tuesday
etc.?

you could use this formula

=TEXT(DATE(2006,7,1),"dddd")

or just put the date in a cell and format that cell as dddd


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523259

=3*(DATE(YEAR(TODAY()),7,1)=A2)*(DATE(YEAR(TODAY( )),7,1)<=A3)

Whe
A2: 6/25/2006
A3: 7/21/2006

To answer your question directly you can use the formula above. I am a
little confused as to what you are actually trying to do though. There might
be an easier way. Give an example (using actuall cell references) of what is
given, and what you want the results to be.

"ben simpson" wrote:

What I'm trying to do is find out if the 1st day of July falls within a range
of dates, let say June 25th and July 21st (actual dates can be referenced
easily). Using the formula =DATE(YEAR(TODAY()),7,1) , how can a formula be
created to check that, and if true, return a 3, and if not, than a 0?




"Sloth" wrote:

=DATE(2006,7,1)

or (for current year)

=DATE(YEAR(TODAY()),7,1)

or (to get the day of the week, ie. Sunday, Monday, Etc.

=TEXT(DATE(YEAR(TODAY()),7,1),"dddd")

"ben simpson" wrote:

Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?