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)

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)

two variable dates created from a single date
 

Works! You've been a life saver, ttthhhaaannnkkksss!!!

"JMB" wrote:

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)

two variable dates created from a single date
 

Quite welcome.

"Lindsay" wrote:

Works! You've been a life saver, ttthhhaaannnkkksss!!!

"JMB" wrote:

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)