Balance of Year Macro?

**Sep280** · 08-22-2007, 10:51 AM

I am looking for some help writing a macro to use different formulas depending on the month. I am trying to get it to do a balance of year total and then for it to help me get a balance of year price. (Aug -Dec, or if it is July then July-Dec). I have attached a sample of what I'm working with. Any help is greatly appreciated! Thank you!

**royUK** · 08-22-2007, 10:55 AM

Why do you need a macro? You can use Functions

**Sep280** · 08-22-2007, 02:08 PM

Thank you very much. This will work, and its much easier than a macro. Thank you again.

**Sep280** · 08-22-2007, 03:39 PM

=SUM(OFFSET(A2,0,0,1,MONTH(NOW()) + IF(MONTH(NOW())>3,-3,3)))

I gave that a try... I'm not sure it will work. Is this something I can pick the month on? The spreadsheet I'm working with is something that I will want to use to look at options coming up. If it is now August I might want to look at options for October balance of the year...
I appreciate any help, Thank you!

**Ikaabod** · 08-22-2007, 05:01 PM

replace "now()" with a cell (example: "A1") then type the date you want to look for in cell A1... the MONTH function will determine the month of the date that you enter. YEAR and DAY functions do the same thing, returning the year and the day, respectively.

Hope that helps.

**royUK** · 08-23-2007, 04:40 AM

One of the formulas in the original example was missing. I have replace the attachment with an amended example & added a demo of what ikaabod was suggesting.