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?

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?

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?