Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I tried to use all the formulas in the response,but could not get them to work.
This is the formula I used, =IF(D91095,"4",IF(D9730,"3",IF(D9365,"2",IF(D9 0,"1")))) If I enter 2 in D9 cell value will be 1 365 1 366 2 735 3 etc. With a max of 4 after 1095 It works if you enter a numeric value in D9. I need it to work off of todays date. I will be using this for years, I do not need leap year to count unless it will throw the sheet off during leap year. I hope this provides enough information. |