Thread: IF Formula to calculate whether date has passed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default IF Formula to calculate whether date has passed
=IF(A1A2,"Yes","No")

Dave
--
Brevity is the soul of wit.


"Janelle Lister" wrote:

What formula can I use that will insert "Yes" if the date in cell A1 is after
the date in cell A2, for example.
Reply With QuoteReply With Quote