Thread: two variable dates created from a single date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lindsay Lindsay is offline
external usenet poster
  
Posts: 21
Default two variable dates created from a single date
Me: total newbie, in a hurry. please tell me how, THANKS!

User enters a date in column A (m/d/yy).
Formula in column B needs to show column A date plus 60 days (m/d).
Formula in column C needs to show column A date, minus whatever # of days
until 1st day of that month, then plus one year (m/1/yy).
e.g., 2/1/08 (column C) derived from user entry 2/17/07 (column A)

Reply With QuoteReply With Quote