View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Automatically update month

=(6.67*month(today()))-0.04



Smilingmom wrote:

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


--

Dave Peterson