I am new to this forum and I have searched low and high through here and google searches. I can not for the life of me figure out how to create/use a formula to where I can, on one row do weeks (1-52/3 weeks but dated). I.E. E/F 5, G/H5 merged cells and so forth. Example of dates would be: In row e/h5 1/1/2021-1/2/2021, 1/3/2021-1/9/2021, 1/10/2021-1/16/2021, .... to 12/26/2021-12/31/2021. I am using these rows to show a weeks worth of income/expenses in one column. I have tried to do 2-3 continuous cells and trying to fill beyond but it skips to 2022 then 2023 and so forth. I hope that my explanation is sound enough, if not poke and prod my blank, caffeine deprived brain.
Bookmarks