View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default two variable dates created from a single date

in column B, try
=A1+60
formatted as m/d

in column C, try
=DATE(YEAR(A1)+1,MONTH(A1),1)


"Lindsay" wrote:

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)