two variable dates created from a single date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
in column B, try
=A1+60
formatted as m/d

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