Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Created Date | Excel Worksheet Functions | |||
Date formatting of formula created dates | Excel Discussion (Misc queries) | |||
how do I make single character as a variable in an array | Excel Worksheet Functions | |||
Excel 2003 Referencing multiple workbooks via single variable | Excel Worksheet Functions | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) |