| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for first saturday of quarter
the below formula works but i need to add months 6 and 9 (this would be the
first saturday of the quarter. I can't seem to add another month for some reason but i am a newbie. =IF(OR(MONTH(E1)=1,AND(MONTH(E1)=3,DAY(E1)<8)),"*I CCFQRTR"," ") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER | Excel Worksheet Functions | |||
| Formula - Period Quarter End | Excel Worksheet Functions | |||
| Excel should have a QUARTER formula for DATE calculations | Excel Worksheet Functions | |||
| Formula for Calendar Quarter | Excel Worksheet Functions | |||
| Formula to fill inthe Quarter | New Users to Excel | |||
Threaded Mode
