View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cray_z77 Cray_z77 is offline
external usenet poster
 
Posts: 2
Default How can I increase the value in a cell based on the changing date

At work, we need a "cycle" number that increases by 7 every day. What kind of
formula could a use that would the value in "A1" (Say 5) and increase by 7
every day?

Thank you.