View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
XLS S XLS S is offline
external usenet poster
 
Posts: 12
Default Date sensitive formulas

You can use if condition like

if(col < date,x,"")

col - you column
date- stop date
x - your formula


On Wednesday, 27 July 2016 21:19:06 UTC+5:30, prattingabout wrote:
Hi


Is there anyway to stop a formula from updating after a specific date
without manually pasting values?


Any help would be really great, thank you.




--
prattingabout