B
ben simpson
Whats the easiest way of finding the 1st day of a month (lets say July for
instance) of the current year?
instance) of the current year?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
daddylonglegs
Do you mean you want to know whether 1st July is a Monday, Tuesda
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 ddd
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 ddd
T
Toppers
Ben,
If you mean day (of week) then:
=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
Where A1 contains a date
HTH
If you mean day (of week) then:
=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
Where A1 contains a date
HTH
B
ben simpson
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?
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?
S
Sloth
=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")
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")
P
Paul Lautman
Isn't =TEXT(A1,"ddd") rather simpler?Toppers said:Ben,
If you mean day (of week) then:
=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
B
ben simpson
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
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
S
Sloth
=3*(DATE(YEAR(TODAY()),7,1)>=A2)*(DATE(YEAR(TODAY()),7,1)<=A3)
Where:
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.
Where:
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.