Search results

Thanks Narayan, it was a paid product purchased last week. I will send you the file. Many thanks.

Hello, Just downloaded these awesome templates. Wanted to ask, if I wanted to reflect only 7 Phases instead of the 10, how do I go about it in a way that I dont have to update the formulas and the percent complete is updated accordingly. Many thanks. Effendi

Thank you John! This community rocks! :)

Many thanks Eibi! It works, just changed the date operator to < and all conditions are met. Thank you so much! Best. Effendi

Hello, I am new to using formulas and struggling to get this right. I've attached a file to illustrate the True condition I'm trying to achieve with my IF statement. I'm ok using IF statements alone, however, I've a feeling this requires a combination. Hope I was clear in my explanation and...

Narayan, I dont see your name on the donate section. Would like to send a little token of appreciation your way. Send me your email.

As always, big thanks Narayan. This was great. I've used the date value function to reflect these now as dates and your forumula works. Cheers. Effendi

Narayan, many thanks for your help so far. Pardon my basic level, but I'm getting an issue applying the same formula to the set of tables in this file. I've applied the date format and the same formula but it returns False. Any help appreciated.

Awesome, got it!

Narayan, you rock. Many thanks. What is the function which is highlighting the cell?

Hello, I have a question around the best strategy to analyze a bunch of date ranges. The excel file (extracted from a Microsoft Project Plan) I've attached has example milestone dates for 10 diff projects. Each milestone (1-8) needs to occur sequentially. At times the users do not populate the...

Hello, Great forum! I recent purchased the excel school package (2 days ago) but havnt received any instructions about the log in details? Can any one advise what is the general procedure and wait time as the payment receipt stated 24 hours? Thanks. Effendi

Hui, thank you so much! I feel so powerful with this formula! Best. Effendi

Hope someone can help. I have 2 date columns. The columns have a start and finish date . The dates span 2005-2010. The rest of the columns are blank columns for 2005 to 2010. What I would like to ask the experts here is how I could indicate in the blank columns whether it spans a particular...