I need a formula that will automatically insert the next Saturday's date in a field on a form in the format dd/mm/yyyy.
Thanks
I need a formula that will automatically insert the next Saturday's date in a field on a form in the format dd/mm/yyyy.
Thanks
Last edited by JuJuBe; 07-22-2010 at 12:05 PM.
Depending on whether you want the Saturday that's 0 to 6 days later, or the one that's 1 to 7 days later,
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
One way, assuming the date is in cell A1:
Please Login or Register to view this content.
Regards
That was easy. Thanks!
You're welcome. Thanks for the feedback.
Thanks, helped me as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks