Daily Variance
 

Hello,

I need help with a daily variance function. I have a formula to get a daily
variance from today to same day last month.

Today Previous month Variance
13,852 11,775 2,077 (Today-Previous Month)

I want to change it from Today to the first business day of each week.
could you help on determining this function?

Daily Variance
 

If you want the first Monday of the week containing the current day, try this:

=(TODAY()-WEEKDAY(TODAY())+2)

Or...if holidays may be an issue:

With a list of holiday dates in G1:G10
=WORKDAY(TODAY()-WEEKDAY(TODAY())+1,1,$G$1:$G$10)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jose Aleman" wrote:

Hello,

I need help with a daily variance function. I have a formula to get a daily
variance from today to same day last month.

Today Previous month Variance
13,852 11,775 2,077 (Today-Previous Month)

I want to change it from Today to the first business day of each week.
could you help on determining this function?

Daily Variance
 

Yeap. Thank you very much.

"Ron Coderre" wrote:

If you want the first Monday of the week containing the current day, try this:

=(TODAY()-WEEKDAY(TODAY())+2)

Or...if holidays may be an issue:

With a list of holiday dates in G1:G10
=WORKDAY(TODAY()-WEEKDAY(TODAY())+1,1,$G$1:$G$10)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jose Aleman" wrote:

Hello,

I need help with a daily variance function. I have a formula to get a daily
variance from today to same day last month.

Today Previous month Variance
13,852 11,775 2,077 (Today-Previous Month)

I want to change it from Today to the first business day of each week.
could you help on determining this function?