Robert has attended:
Excel Advanced course
Monitoring KPIs - 1 month deadline
Hi,
I need to monitor some KPIs and I would like to know how I can formula to show if a date is outside of a 1 month turnaround. I am trying to use the IF function but I'm not sure how to make this work.
Any ideas would be greatly appreciated!
Rob
RE: Monitoring KPIs - 1 month deadline
Hi Robert,
Thank you for the forum question.
I do not know how you have organised your data, but I have a suggestion to do what you want.
Please find attached file (if you cannot see the attachment please refresh your browser).
I have used the If function, but I have also done an example where I am using conditional formatting.
I hope my examples make sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
targets.xlsxRE: Monitoring KPIs - 1 month deadline
Hi Jens and thanks for getting back so quickly. I can't see the attachment anywhere. Sorry it's my first time using the forum. I tried refreshing the page but it still wouldn't show.
Rob
RE: Monitoring KPIs - 1 month deadline
Scratch that last message I can see the attachment now! :-)
RE: Monitoring KPIs - 1 month deadline
Thanks for that Jens. It's not quite appropriate for what I'm doing. Basically I need to flag if one date is more than a month after another date. I've taken a screen shot but I can't see how to attach it.
RE: Monitoring KPIs - 1 month deadline
Hi Robert,
Please find attached file.
If you cannot see the attachment, wait few minutes and refresh the browser.
I have used the Edate function inside an If function.
Please let me know if this is what you want.
Thanks
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Monitoring KPIs - 1 month deadline
HI Jens. That's closer. I was thinking more like =IF(AL2<EDATE(AH2MONTH),1,0) (obviously this isn't a valid formula but the deadline is 1 month or less so I need the value to be 1 if the date in AL2 is more than 1 month after the date in AH2)
RE: Monitoring KPIs - 1 month deadline
Hi Robert,
Try
=IF(AL2<=EDATE(AH2,1),1,0)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Monitoring KPIs - 1 month deadline
Thanks Jens I think that's done the trick! :-)
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
