| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formulea for calculating a month
I trying to create a stats monitoring sheet and i need to calaculate the
target peiod The target is to conduct the interview within 3 months of the start of the month in which the interview became due. IThe date that it is due will be given. how do i tell excell to go back to the start of that month and then calcualte a 3 month window from there? Also i need both dates to be shown as the target window |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formulea for calculating a month
how do i tell excell to go back to the start of that month
A1 = some date =A1-DAY(A1)+1 then calcualte a 3 month window from there Assume the above formula is in cell B1. =DATE(YEAR(B1),MONTH(B1)+3,DAY(B1)) Biff "drizzy" wrote in message ... I trying to create a stats monitoring sheet and i need to calaculate the target peiod The target is to conduct the interview within 3 months of the start of the month in which the interview became due. IThe date that it is due will be given. how do i tell excell to go back to the start of that month and then calcualte a 3 month window from there? Also i need both dates to be shown as the target window |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formulea for calculating a month
ta very much for that.
Is is hard to make it give me the day before the end of the 3 months? caus ei need all action complete within the 3 months so the end of the 3rd month would be a day too late "T. Valko" wrote: how do i tell excell to go back to the start of that month A1 = some date =A1-DAY(A1)+1 then calcualte a 3 month window from there Assume the above formula is in cell B1. =DATE(YEAR(B1),MONTH(B1)+3,DAY(B1)) Biff "drizzy" wrote in message ... I trying to create a stats monitoring sheet and i need to calaculate the target peiod The target is to conduct the interview within 3 months of the start of the month in which the interview became due. IThe date that it is due will be given. how do i tell excell to go back to the start of that month and then calcualte a 3 month window from there? Also i need both dates to be shown as the target window |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formulea for calculating a month
Just subtract 1 day:
=DATE(YEAR(B1),MONTH(B1)+3,DAY(B1))-1 Biff "drizzy" wrote in message ... ta very much for that. Is is hard to make it give me the day before the end of the 3 months? caus ei need all action complete within the 3 months so the end of the 3rd month would be a day too late "T. Valko" wrote: how do i tell excell to go back to the start of that month A1 = some date =A1-DAY(A1)+1 then calcualte a 3 month window from there Assume the above formula is in cell B1. =DATE(YEAR(B1),MONTH(B1)+3,DAY(B1)) Biff "drizzy" wrote in message ... I trying to create a stats monitoring sheet and i need to calaculate the target peiod The target is to conduct the interview within 3 months of the start of the month in which the interview became due. IThe date that it is due will be given. how do i tell excell to go back to the start of that month and then calcualte a 3 month window from there? Also i need both dates to be shown as the target window |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Month To Date Revenue | Excel Worksheet Functions | |||
| Calculating Month Name | Excel Discussion (Misc queries) | |||
| filter list of text for unique entries using formulea | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating days in a month | Excel Discussion (Misc queries) | |||
Linear Mode
