View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Smilingmom Smilingmom is offline
external usenet poster
 
Posts: 3
Default Automatically update month

In the formula below, I would like "X" to be the month's number, eg: Jan=1,
Feb=2, etc., but update automatically based on the current month. So if it is
April, it would change to 4 on the first of April. Thanks for you help!

=(6.67*X)-.04