TheBigCountry
New Member
I have a spreadsheet where I have enter a date in one cell, and then it autofills the rest of the sheet by using B1+1, B2+1, etc.
At the beginning of each weekly group, I have a summary saying Week: and then I've written a formula =(B42&"-"&B47) so that it shows Week: 12/22/15-12/27/15 (as an example)
However, in the cell where I have my week (in the example above 12/22/15-12/27/15, the result is showing up as 42360-42365 instead of dates. I know this is related to a formatting issue but can't figure out how to fix it.
At the beginning of each weekly group, I have a summary saying Week: and then I've written a formula =(B42&"-"&B47) so that it shows Week: 12/22/15-12/27/15 (as an example)
However, in the cell where I have my week (in the example above 12/22/15-12/27/15, the result is showing up as 42360-42365 instead of dates. I know this is related to a formatting issue but can't figure out how to fix it.