Thread: How do I get a cell to give a result based on the month we are in?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SHBmgr SHBmgr is offline
external usenet poster
  
Posts: 2
Default How do I get a cell to give a result based on the month we are in?
I want to calculate the % difference between actual and goal for the month we
are in. i.e. J1=I1/C1(when we are in Feb), or J1=I1/E1(when we are in
April). In other words, the answer for J1 will reflect whatever month we are
currently in. If you open up the spreadsheet in July it will be J1=H1/I1. I
think the formula may involve the TODAY function but I am not sure.


A B C D E F G H I
J
Jan Feb Mar April May June July Goal % Diff
1 Product 1
2 Product 2
Reply With QuoteReply With Quote