Hi all
I've made a simple table of seasons and the time of year (see attached). At the minute the winter cell starts at the start of the new year, can this be adjusted to move into the previous year row slightly? essentially this is because winter starts in December, not Jan.
Thanks in advance.
Merged cells are the spawn of Satan. Absolutely best avoided... (almost) always.
https://excel.solutions/2016/10/usin...ctively-excel/
Will you be having formulae in the Zone 1,2,3 cells... or will you just be entering values that you will do nothing with?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If you think about it it's column A that is not showing the correct information, i.e Winter is NOT (as you say) all in 2022
I'd be inclined to show the Actual start date. So in A2 1/12/2021, then in A3 copied down =EDATE(A2,3)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks