Hi I am semi new to using excel and I am trying to create a spread sheet for work. It looks at the amount of days an animal stays with a fosterer on a monthly spreadsheet.
I understand the formula of =INT(G56)-INT(F56) however what i'm struggling with is if the animal hasnt left yet. Is there a way that if f56 is blank it will uses the last day of the month instead to work out the number of days?
dates.png
I have no idea if this is something that can be done.
I hope this makes sense, Thank you for your help.
Sarah
Bookmarks