fiscal periods- ending first friday of everymonth

[soltek]

Could anyone help me with a formula that would determine our monthl
setup? Every month closes on the first friday of the next month

 

[JE McGimpsey]

Take a look at

Nth Day Of Week For A Month And Year
http://cpearson.com/excel/DateTimeWS.htm

 

[Ron Rosenfeld]

Could anyone help me with a formula that would determine our monthly
setup? Every month closes on the first friday of the next month.

With a date in A1, this formula should give the first Friday of the following
month:

=DATE(YEAR(A1),MONTH(A1)+1,1)+7-
WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,2))
--ron

 

[soltek]

That works terrific thank you very much. If anyone minds would you know
how to formulate the number of weeks between two dates?

 

[Ron Rosenfeld]

That works terrific thank you very much.

You're welcome. Thank you for the feedback.

If anyone minds would you know
how to formulate the number of weeks between two dates?

=(EndDate - StartDate)/7


--ron

 

[soltek]

I found this formula that gives me the number of weeks between tw
dates.
=TRUNC((B25-A25)/7)&" Weeks "&MOD(B25-A25,7)&" Days"

Can this be adjusted to round up or down to the nearest number o
weeks? i.e. 4 weeks and 4 days = 5 weeks...??

And to go deeper, how could I use this to form totals for each of thes
weeks?? thanks in advance

 

[JE McGimpsey]

one way:

=ROUND((B25-A25)/7,0) & " weeks"

 

[Ron Rosenfeld]

I found this formula that gives me the number of weeks between two
dates.
=TRUNC((B25-A25)/7)&" Weeks "&MOD(B25-A25,7)&" Days"


Can this be adjusted to round up or down to the nearest number of
weeks? i.e. 4 weeks and 4 days = 5 weeks...??

Use the ROUND formula that McGimpsey posted

And to go deeper, how could I use this to form totals for each of these
weeks?? thanks in advanced

You could use SUMIF formulas;

=SUMIF(25:25,">="& StartDate,26:26) - SUMIF(25:25,">="& EndDate,26:26)

--ron