Thread: date range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default date range

hi
if you have a date in F3 and compared that to today,
=IF(F3<TODAY(),TODAY()-F3 & " Days early",F3-TODAY() & " Days Late")

regards
FSt1

"keshia" wrote:

how to you enter a formula to determine how many days early or late