November72
New Member
Hello - Thanks in advance for any help anyone can provide.
I've been trying to get a calendar date formula to work in a new workbook and am having trouble. I can get the first one to work, but none after that. I want to have pay dates populate thru a workbook from one worksheet to the next.
I have January set up and have the first date entered fine. I can get the next date to populate in the next cell I want it to fine, as well, by taking (Date 1) + 14. Then if I go to the next sheet and try to take create a formula using (Date 2) + 14 Excel doesn't like that.
Any suggestions for how to make this work? Or should I quit wasting my time with a formula and just type them all old school.
I've been trying to get a calendar date formula to work in a new workbook and am having trouble. I can get the first one to work, but none after that. I want to have pay dates populate thru a workbook from one worksheet to the next.
I have January set up and have the first date entered fine. I can get the next date to populate in the next cell I want it to fine, as well, by taking (Date 1) + 14. Then if I go to the next sheet and try to take create a formula using (Date 2) + 14 Excel doesn't like that.
Any suggestions for how to make this work? Or should I quit wasting my time with a formula and just type them all old school.