Thread: Daily Variance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jose Aleman
 
Posts: n/a
Default 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?