Schedule

[BullseyeThor]

Hi Guys

Need help or really just a querie. I have a spread sheet that uses dates to keep track of things.

I also have a column that states the current progress of the stores that its used for. (Complete, Pending and In Progress).

Is there a formula that can change this cell to one of the 3 depending on the real time date.

E.G I have shop fit start and D.O.E snag End anything before the start date I need to say pending, anything between I need to say In Progresss and after D.O.E end I need, of course, complete.

I need a formula though becuase I have had to make the file a shared file so the team can access it so can't use the VBA.

Thanks
Guys

 

[Upex]

A nested if formula should work for you.

Why is VBA ruled out? it can still function in a shared file, you just can't edit or view the code without unsharing it.

 

[BullseyeThor]

It won't let me unshare it not sure why.

How would I do the nested if formula?

 

[Upex]

This sould work for a set up of A:A = Status, B:B = Start, C:C = End

It's not letting me display the formul properly, so will PM you

 

[Upex]

Have sent you PM with formula on:

=IF(TODAY()<B2,"Pending",IF(TODAY()<C2,"In Progress",IF(TODAY()>=C2,"Complete","Check Dates")))

<B2,"PENDING",IF(TODAY()<C2,"IN Progress?,IF(TODAY()>