Hi Team,
I just want to add a cell for a date with current payweekending+1.
How can I identify current payweekending date.
Please see attached my working and expected result.
Thank you.
regards,
Aye
Hi Aye,
I suspect there might be some information missing as this is a fairly easy IF formula:
=IF(F1="Y",F3+1,"")
Please let me know if I misunderstood.
Mynda
Hi Mynda,
I am sorry for not clear enough.
"Y"column are for current pay and it will be different each pay. I just require a set date for 2 cells only.
My formula is more like the following for the range of cell.
=IF(cell in B1:I1 ="Y" then cell in B3:I3,+1 else "")
thank you.
Regards,
Aye
Hi Aye,
Still not completely clear, but I'm assuming you want to find the first instance of Y in row 1 and return the date in row 3 + 1. The second date is simply 7 days later, in which case you could use HLOOKUP or INDEX & MATCH to find the first date, then add 7 to that result. e.g. in cell K3:
=HLOOKUP("Y",$B$1:$I$3,3,0)+1
In cell L3:
=K3+7
If I have misunderstood, please provide more scenarios and desired results so I can understand the complexities.
Mynda
Many thanks, Mynda.
Hlookup works.
Regards,
Aye
