Luke M,
Thanks for the swift answer, I knew you could string them together, just the grey matter refusing to play.
I will give it a go when i get home
Daz
Ok, firstly a hello to everyone, i have been lurking on the sire receiving the daily tips for a while, but thought it is time to register and talk to the team.
I have been using Excel since Excel97, and have been able to make it do what I need over the years, but in the last 6 months am now...
Ladies and gents,
I need your advice on the cleanest formula/method of setting cell content base on a date.
I have a date that a service is due.
The service may be overdue (negative number, due in the next 30 days,90 days or in the future.
I have column A which has the due date, column B...