Hello,
First, let me say I know nothing about Excel plainly put. I do computer maintenance and networking for the non-profit I work for. So my boss is too embarrassed to come on here and ask
a rookie question, so she put me up to it. The image I uploaded is the time sheet she uses. She needs a formula where for example, when she types in 4 in C16 for the next pay period, it will make the date in E16 advance two weeks and show August 10 2023. She has a formula in G16 that reads =E16+6.5*2 that makes G16 show the correct date in it for the end of the pay period. Now, she just needs the formula for C16, or E16, or wherever it goes so she only has to change the number in C16 and everything else advances if thats possible. She also has the days of the weeks set up
with a formula to make them advance
Thanks in advance for your help.
First, let me say I know nothing about Excel plainly put. I do computer maintenance and networking for the non-profit I work for. So my boss is too embarrassed to come on here and ask
a rookie question, so she put me up to it. The image I uploaded is the time sheet she uses. She needs a formula where for example, when she types in 4 in C16 for the next pay period, it will make the date in E16 advance two weeks and show August 10 2023. She has a formula in G16 that reads =E16+6.5*2 that makes G16 show the correct date in it for the end of the pay period. Now, she just needs the formula for C16, or E16, or wherever it goes so she only has to change the number in C16 and everything else advances if thats possible. She also has the days of the weeks set up
with a formula to make them advance
Thanks in advance for your help.