View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default What formula would transpose stale dated cells?

Hi,
Not quite sure what you're after, but I'll have a go as much as I understand
the question.
If your stale date (does that mean a date older than today?) is in A2,
then in B2 put =IF(A2<TODAY(),"Stale","")
If you really want the old date in the new cell, then:
=IF(A2<TODAY(),A2,"")
For the 2nd option, make sure B2 is has a date format.
Regards - Dave.