Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating date and placing the value in the right date range col
I want to calculate a date and then place the date value in the correct
column. Columns will be date ranges. For example, I calculate a date to be 7/15/09. I have columns with 2 week ranges such as: Column A B C 6/29/09 - 7/12/09 7/13/09 - 7/26/09 7/27/09 - 8/9/09 I want the 7/15/09 date value placed under the B column at the current row position. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help Please calculating date range - Other posts didn't help | Excel Worksheet Functions | |||
Calculating Salary based on Date Range | Excel Worksheet Functions | |||
Calculating data within a date range | Excel Worksheet Functions | |||
Calculating for a specific date range | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |