what i need is a formula that will self populate along the top of a sheet that every column will be the friday of the week unless there is a last day of the month in the range.
For example if i put in yesterdays date 3/20/2008 in cell A1, B1 would be 3/21/2008, C1 would be 3/28/2008, D1 would be 3/31/2008 and so on.
Hello.
How can I code a cell to return the "First Friday in a given month"?
Please assume that cell A1 contains a date which represents the first
day in the month (i.e. 1/1/05 or 5/1/13).
Thanks.
Michael
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Hi I'm trying to find a formula that will return the first Friday in a month.
Month is text value in Cell B2
Year is number value in cell B3
Any help is great, thank you
At the moment I'm using two formulas to get the date for specific weekday:
for last Friday
Code:
=TODAY()-WEEKDAY(TODAY()+2, 2)
for next Friday
Code:
=TODAY()+7-WEEKDAY(TODAY()+7-6)
How could I use these two days to count all dates In col A that fall between these two days (inclusive)
Also how could I count all dates in column A that older than last weeks Friday
Any help is appreciated
Cheers
Rain
Is it possible to write a formula to find the date of the fourth friday in each month?
Thanks
Hi,
I want to creat a list in a spreadsheet that will show the date for each friday and wednesday in a month. If i enter the date of the first day of the month in cell A1 for example, is there a formula that will create the rest for me?
Thank you for your help in advance.
I am trying to construct a schedule of tasks to be done by certain dates. If the last day of the month is entered (say 11/31/09) in a cell, is it possible to find out the date for the third Thursday of November or the first Wednesday or the last Friday?
Without VB, is there a way to write a formula which when given a certain month, will output the date of, let's say, 2nd or last friday of the month?
In cell A1 I have a date (like 8/1/08)
In A3, B3, and C3 I need to have the first Monday, Thursday, and Friday of the month. Here's the caveat, I need A3 to have the day that comes earliest in the month.
In this case, A3 would contain 8/1/08 since it's the first Friday, B3 would have 8/4/08 as the first Monday, then C3 would have 8/7/08 as the first Thrusday.
If A1 contained 7/1/08 then A3 would have 7/3/07 as the first Thursday with Friday and Monday following.
Any thoughts on this?
Hello again,
I received a positive response from the introduction of my little project, which got me thinking - how about adding to it...
I have a few sites I manage, but other regions have several more, which is what I'm trying to adapt to. I've uploaded the doc to 4shared again.
Topic 1:
Find the frist Friday of the month. Would I start with IF(), DATE(), MONTH() ...?
http://www.4shared.com/file/18864952...estimator.html
Topic 2:
Can the 3 tables "expand" as more names are added to the site name sheet? I remember very little of PHP, but I remember a +1 line added upon __. Does excel have the functionallity? Is the diving into macros?
Josh
Ideas, suggestions, beginnings, formula-types to get me started in the correct direction would be great!
