SOLVED I am a nurse and trying to determine an easier way to calculate days covered under Medicare so I an not doing this manually each month. I am also new to excel, so I will try to be as detailed as I can. Thank you for any help.
Thank you so much,
Una
MY FILE CAN BE DOWNLOADED FROM RAPIDSHARE - http://my.rapidshare.com/UNAB/19016
1. NEED FORMULA FOR:
IF A14=A13 AND IF H14 = 07. Unscheduled THEN E14 WILL BE 7DAYS LESS THAN D14 THEN F13 WILL BE ONE DAY LESS THAN E14
2. NEED FORMULA FOR:
J AND K TO INCLUDE ONLY THE FEB DATES FROM E11 AND F 11
Bookmarks