Daily Variance

[Guest]

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?

 

[Guest]

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

 

[Guest]

Yeap. Thank you very much.

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