Thread: How do I set a start and expiration date using IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
  
Posts: 694
Default How do I set a start and expiration date using IF function
Hi John
You can type a date in one cell e.g. A2 or you can press Ctrl+; semicolon to get
today's date and in an other cell just type =A2+6.
HTH
John
"John A" wrote in message
...
I want to be able to have the computer to give me a expiration date at the
end of the 6th day starting today

Reply With QuoteReply With Quote