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
|