In H6 Cell
=IF($J$4="Weekly",$R$4+((COLUMNS($A:A)-1)*7),EDATE($R$4,COLUMNS($A:A)-1)-WEEKDAY(EDATE($R$4,COLUMNS($A:A)-1),15)+1)
Drag it right...
In H6 Cell
=IF($J$4="Weekly",$R$4+((COLUMNS($A:A)-1)*7),EDATE($R$4,COLUMNS($A:A)-1)-WEEKDAY(EDATE($R$4,COLUMNS($A:A)-1),15)+1)
Drag it right...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks