I was wondering if this was possible. I have a formula that in order for it to work, it needs to factor in the current day of the quarter for our school year.
For example, today (May 4th) is day 24 of the 4th quarter.
Is there a way through excel that I could have the today function return a specific value to a day of quarter cell?
In my spreadsheet for example I would need to return 22 for 5/2/11, 23 for 5/3/11, etc. ExcelHelp.xlsx ExcelHelp.xlsx