LinkBack URL
About LinkBacks
Hello,
I need to add a time statement to a formula.
I am looking to add this: +TIME(0,0,1)
To this: =EOMONTH($B8,-MOD(MONTH($B8)-1,3)-1)+1
To add more, in Cell B8, I have this formula: =TODAY()+TIME(5,59,59)
I appreciate any help.
thank you,
Nick
Hello,
I need to add a time statement to a formula.
I am looking to add this: +TIME(0,0,1)
To this: =EOMONTH($B8,-MOD(MONTH($B8)-1,3)-1)+1
To add more, in Cell B8, I have this formula: =TODAY()+TIME(5,59,59)
I appreciate any help.
thank you,
Nick
Have you tried:Formula:
Please Login or Register to view this content.
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
I really appreciate your sharing this information.
or:
=DATE(YEAR(B8),1+3*INT((MONTH(B8)-1)/3),1)+1/86400
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
I forgot to close this one out, Thank you Glenn and TMS!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks