two variable dates created from a single 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)
 
G

Guest

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
CALCULATING DATES 3
Difference of date 5
Excel display two dates in one cell - excel 2010 2
calculating dates 2
Fill a blank cell with a value using if conditions 7
Sum variable range of column entries in offset cell 5
Calculating calendar days and completion dates. 4

Top