Recent content by razaas

You have not given any formula for 3rd row. Because I am not expert like you. I knew my solution might not be perfect that is the reason I asked for your comments and suggestions, you gave only comments but no suggestions. Highly appreciate your comments, your formulas for first two rows...

Hi Narayan, Don't be so arrogant please, I did not ask you for another formula, appreciating your super skills I just asked your comments and suggestions on the formula in the attached file, few of my comments which I think you ignored what I meant was for all cells in each row which I...

Hi Narayan, I think you didn't read my previous reply and not checked the attached file. Thanks

Hi Narayan, Thanks a lot, it works well, but you missed the 3rd highlighted row, in the mean time i tried myself and succeeded with very long IF formula and first row with hard coded numbers, i wanted one formula for all cells, sample attached for your comments and suggestions. Please check...

Thanks a lot NarayanK991 for looking into my query, yes the number of columns will be 8 only, max input value cell K5 can be 2500 and all other Qs "yes" you guessed them correctly. Thanks, Raza

Please help with 3 formulas to auto populate the numbers, sample highlighted in yellow, in the attached excel file. Cell K5 is the input number, based on K5 all yellow highlighted cells shall auto populate in the pattern shown in Table 1 and if the assigned formulas working fine then the result...

Thanks Hui, Your 1st formula is really good and I am very happy with it as I compare it with my crude and layman kind of formula. You are so kind to provide another formula which seems not working as I desired, the reason might be that you are not aware of the actual dates I have which are now...

Thanks again Hui, I needed to get the anniversary dates if the month and day already passed then in that case the result should be next years' date. If the month and day yet to pass then current year, for which your second formula fails as you can see below the dates on right side. Also the...

Awesome! Thanks a lot, it is highly sophisticated than my formula. Have great day.

Hi all, I have dates in column D and I am using this formula “=IF(DATE(YEAR(TODAY()),MONTH(D3),DAY(D3))>DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),DATE(YEAR(TODAY()),MONTH(D3),DAY(D3)),DATE(YEAR(TODAY())+1,MONTH(D3),DAY(D3)))” in next column to determine the anniversary dates, the formula...

Sorry the file was not attached to my previous post.

HI, I need further help, Sam's "ISNUMBER, MATCH, OFFSET" formula working fine on attached file but as an improvement I am trying to export calender from sharepoint to my data input (sheet1, row 28 onwards). The exported dates have time included, therefore need help to alter the existing...

Sam, Thanks a lot, it works perfectly and your help highly appreciated. Have a great day.

Hi Sam, Thanks and it is almost as I wanted, but if you look at my sample formula, it is excluding weekend and holidays. I want weekend and holidays to be blank, for that I used NETWORKDAYS.INTL function into my formula, so if you can modify your formula to give blank cells on weekend and...

Please see the attached file, what I want is match the selected month and name in sheet "view", cells B2 and A4 with the names and dates listed in sheet 2. The sample shown in "view" sheet is data matched from sheet 1. I want the same kind of output but with selected month and name and you may...