I would like to add 12 weeks to a date in cell D3 but then it goes past 52. How can I get it to go 51,52,1,2,3, etc
any help appreciated
I would like to add 12 weeks to a date in cell D3 but then it goes past 52. How can I get it to go 51,52,1,2,3, etc
any help appreciated
Last edited by nigelog; 02-01-2017 at 06:02 AM.
=if((weeknum(d3)+12)>52,((weeknum(d3)+12)-52),(weeknum(d3)+12))
sorted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks