|
|
|
|
#1
09-08-2020, 12:00 AM
|
||||
|
||||
Thank you. Tried both formulae and they're perfect. It is my first time to use the FLOOR function.
Edit: In the FLOOR formula, I thought I just need to change the 3 to 1 or 2 just like Arvi's. I was wrong so I will use Arvi's solution. Last edited by Marcia; 09-08-2020 at 02:28 AM. 
|
|
#2
09-08-2020, 04:48 AM
|
||||
|
||||
|
Quote:
No, the 3 does not need to be changed, that is the advantage... FLOOR with a significance of 3 will ALWAYS return the first month of the quarter (1,4,7,10)
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter | PrincessApril | Excel | 6 | 12-06-2019 02:38 PM |
 Format in a formula month and numbers
|
Marcia | Excel | 10 | 02-28-2019 05:55 AM |
|
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date
|
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
|
Formula For Displaying Exact Days of the Month
|
ddhawks | Excel | 2 | 07-12-2016 11:48 PM |
|
Formula to divide if no of days in month is 28
|
shilabrow | Excel | 5 | 06-26-2014 12:17 AM |
Windows 7 32bit 
Office 2013
Hybrid Mode