Hi there,
I am creating a time sheet that has the date in it.. Is there a formula that I can put so that if I just enter the actual date on sunday, it will populate the rest of the week or 2 weeks?
thank you!
Hi there,
I am creating a time sheet that has the date in it.. Is there a formula that I can put so that if I just enter the actual date on sunday, it will populate the rest of the week or 2 weeks?
thank you!
If the date is in A1, then A1+1 will give you the next date.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or just drag the Date down?
This also works for Sun, Sunday, Jan, January, etc.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks