View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FS FS is offline
external usenet poster
 
Posts: 2
Default Adding A Date To Adjacent Cell

I need to know if there is a simple formula to add the current (static) date
into the adjacent cell by entering a specific # into another cell.
Example: by entering 100 into cell A1, I'd like to see the date apear in
cell B1.
Thanks, FS