I would like a formula that I can apply to a cell which has a date in it, so I that I can deduct one week from it. I would also like to know how to have a formula which will instead of updating every day with a new date, as the today function does, it updates only every friday. Then I will use the minus 1 week function beneath it to get the date of the friday of the previous week, and the week before that, and the week before that! Woohoo!
Thanks so much,
This can be very cool!
Hi,
In order to have a cell contain both a formula and a fixed date (for non Friday's) you'll need a macro unless you carry the date as a separate cell and use that as the basis for an if test in another cell.
Let us know which approach you'd prefer.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
an if test would be preferable, thanks
If you're using the 1900 date system,a formula which will instead of updating every day with a new date, as the today function does, it updates only every friday.
=FLOOR(TODAY() + 1, 7) - 1
Entia non sunt multiplicanda sine necessitate
Readers, if you put the formula shg has written above in cell AC43, then you need to put this formula below it
=FLOOR(AC43, 7) - 1
and then drag it down, have a nice day!
thank you shg!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks