| 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) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
| Reply |
| 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) | |||
Linear Mode
