S
Shell
I have a cell C1 with a formula =Now() This gives me 2010
I have another cell C2 with a formula =Now()-100 This gives m1 2009
So far so good
I need to to create a cell value as follows 12/22/LY - 1/21/CY
Where LY would refer back to cell C2 and CY would refer back to cell C1.
This cell would then become 12/22/2009 - 1/21/2010. I cannot use Excel
macros. I would be wrapping this in an if statement so that the next cell
would be 1/22/CY - 2/21/CY
Any help would be appreciated. Thanks
I have another cell C2 with a formula =Now()-100 This gives m1 2009
So far so good
I need to to create a cell value as follows 12/22/LY - 1/21/CY
Where LY would refer back to cell C2 and CY would refer back to cell C1.
This cell would then become 12/22/2009 - 1/21/2010. I cannot use Excel
macros. I would be wrapping this in an if statement so that the next cell
would be 1/22/CY - 2/21/CY
Any help would be appreciated. Thanks